Oracle's semi-equivalent is called 'materialized views'; though I've only seen them commonly used for batch replication purposes.
Axton Grams Joe DeSouza wrote: > ** > 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=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. > <http://us.rd.yahoo.com/evt=42297/*http://advision.webevents.yahoo.com/handraisers> > __20060125_______________________This posting was submitted with HTML in > it___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
