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:
"Heider, Stephen" <[EMAIL PROTECTED]> wrote:
It depends upon the DBMS. SQL Server supports indexed views
http://www.sqlteam.com/item.asp?ItemID=1015
Stephen
-----Original Message-----
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: [email protected]
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 Professional (RSP)
ARS = Action Request System(Remedy)
Solution = People + Process + Tools
Fast, Accurate, Cheap.... Pick two.
Never ascribe to malice, that which can be explained by incompetence.
Do you Yahoo!?
Everyone is raving about the all-new Yahoo! Mail Beta. __20060125_______________________This posting was submitted with HTML in it___
