Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: index on view
In article <9unhgm$7fo1_at_imsp212.netvigator.com>, Cyber says...
>
>Can I create index on view in Oracle 9i?
>
you create indexes on base tables, any/all views on said base tables will (if possible/practical) use the indexes. You do not index views.
You can create indexes on Materialized views but thats a different matter altogether.
>
>--
>http://www-902.ibm.com/hk/sme/corner/solution_detail.html#a3
>http://www.attunity.com
-- Thomas Kyte (tkyte@us.oracle.com) http://asktom.oracle.com/ Expert one on one Oracle, programming techniques and solutions for Oracle. http://www.amazon.com/exec/obidos/ASIN/1861004826/ Opinions are mine and do not necessarily reflect those of Oracle CorpReceived on Thu Dec 06 2001 - 05:51:26 CST