Re: index on view

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: 6 Dec 2001 03:51:26 -0800
Message-ID: <9unm3u02sp7@drn.newsguy.com>

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 Corp

Received on Thu Dec 06 2001 - 05:51:26 CST