Re: Oracle Views and Indexes

[Quoted] Thomas Kyte <tkyte_at_us.oracle.com> wrote in message news:kq1l3s0m6d7sckvla2n1igrktdki6ah4ko_at_4ax.com...
> A copy of this was sent to "Justin Wigg" <justinwigg_at_yahoo.com>
>
> No, there is no such thing as indexes on views. Views will use any and
all
> indexes on the underlying tables.
>
> In Oracle8i, release 8.1, there are function based indexes (white paper at
the
> URL in my signature on this feature) which are indexes on derived columns
(eg: I
> can index upper(cname), or "(a+5)/b")

Thanks Thomas... Just one follow-up: the problem I'm having is a view performing *very* poorly. When I took a look at the view (*not* coded by [Quoted] [Quoted] me - honest!) I realised that it a fourth generation view. ie., this view [Quoted] is based on another view which itself is based on two different views which [Quoted] in turn each select from a combination of views and tables.

[Quoted] Is there any way to tune this up while maintaining the cursor should I re-code all the views so that they only select directly from the tables.

[Quoted] Again, many thanks...

--
Dogs believe they are human.  | Justin Wigg   -    Hobart, AUSTRALIA
Cats believe they are God.    | Reply to:       justinwigg_at_yahoo.com
                    - Unknown | http://www.geocities.com/~justinwigg