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. ________________________________________________________________________ _______ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
