**
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
,
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 someone simply slaps me
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
**
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
**
Hello Mathew,By the way thank you for responding - appreciated...CheersJoe 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 or
To: 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
**
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
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
view..
Joe,
To my knowledge adding an index on a view is not possible. The view
itself has no data
8 matches
Mail list logo