Re: Oracle Views and Indexes

[Quoted] A copy of this was sent to "Justin Wigg" <justinwigg_at_yahoo.com> (if that email address didn't require changing) On Tue, 23 Nov 1999 17:44:02 +1000, you wrote:

>Sorry if this is an FAQ. I searched on Deja but could find an answer...
>
>My workplace runs several Oracle 8.0.5.0.0 instances on a Unix box. I was
>under the impression that O8 would allow indexes to be created on views, but
>have found this not to be the case. Can someone tell me if Oracle 8i
>supports this?
>
>Many thanks...

No, there is no such thing as indexes on views. Views will use any and all [Quoted] indexes on the underlying tables.

In Oracle8i, release 8.1, there are function based indexes (white paper at the [Quoted] URL in my signature on this feature) which are indexes on derived columns (eg: I [Quoted] can index upper(cname), or "(a+5)/b")

-- 
See http://osi.oracle.com/~tkyte/ for my columns 'Digging-in to Oracle8i'...
Current article is "Part I of V, Autonomous Transactions" updated June 21'st
 
Thomas Kyte                   tkyte_at_us.oracle.com
Oracle Service Industries     Reston, VA   USA

Opinions are mine and do not necessarily reflect those of Oracle Corporation