st(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Joe
DeSouzaSent: Tuesday, July 18, 2006 11:10 AMTo:
arslist@ARSLIST.ORGSubject: Re: Performance concern about table field
off a database table view..
**
No you can create a remedy View form out of a database view of a table.. So
I have done t
Cable Project,
Virginia.
- Original Message From: L. J. Head <[EMAIL PROTECTED]>To: arslist@ARSLIST.ORGSent: Tuesday, July 18, 2006 12:33:53 PMSubject: Re: Performance concern about table field off a database table view..**
I may be completely off, and if so I would appreciate it if som
**
I may be completely off, and if so I would appreciate it if
someone simply slaps me, but a View is nothing more than a pre-defined
query. It is true at the DB that you can grant permissions to views and
such but for the purposes of running a remedy table field off of a view that is
just
> From: Action Request System discussion list(ARSList)
> [mailto:[EMAIL PROTECTED] On Behalf Of Carey Matthew Black
> Sent: Friday, July 14, 2006 9:00 AM
> To: arslist@ARSLIST.ORG
> Subject: Re: Performance concern about table field off a database table
>
**
This is nice to know... I am on Oracle however so I guess I have one less consideration to think about.. Joe"Heider, Stephen" <[EMAIL PROTECTED]> wrote: It depends upon the DBMS. SQL Server supports indexed views http://www.sqlteam.com/item.asp?ItemID=1015Stephen -Original Message-F
: arslist@ARSLIST.ORG
Subject: Re: Performance concern about table field off a database table
view..
Joe,
To my knowledge adding an index on a view is not possible. The view
itself has no data in it to index. :)
( and your welcome. I am glad to try to help. :)
--
Carey Matthew Black
Remedy Skilled
**
Thats what I thought but was still wanted to make sure that you didn't have to specify anything spefically to have the view use the index on the parent table. I'm glad you dont :-) Well I guess that pretty much wraps up my design so far on table fields on the design I am working on! It looks
Joe,
To my knowledge adding an index on a view is not possible. The view
itself has no data in it to index. :)
( and your welcome. I am glad to try to help. :)
--
Carey Matthew Black
Remedy Skilled Professional (RSP)
ARS = Action Request System(Remedy)
Solution = People + Process + Tools
Fast,
**
Hello Mathew, By the way thank you for responding - appreciated... Cheers Joe D'Souza Remedy Consultant / Developer, Shyle Networks, New Jersey.Carey Matthew Black <[EMAIL PROTECTED]> wrote: Joe,As you know everything we do on/with the RDBMS affects is performance.(For the better
**
Hello Mathew, Basically I am using the field Status to indicate the status of the ticket and considering that my only clause while building this view of the data table is the Status field as per the requirement I have here, considering that the Status field is an indexed field, I think at th
Joe,
As you know everything we do on/with the RDBMS affects is performance.
(For the better or worst.) The basic design here should be fine.
My only inquiry is to make sure that the searches your doing are
as efficient as possible. For example you indicated that you only want
to show "Open ti
11 matches
Mail list logo
