Re: CREATING VIEWS

AScott wrote:

> Hi,
>
> Does anyone have the answer to the following:
>
> I have created a view based on three tables. How does one create indexes
> on the view? I have tried but failed miserably.
>
> Cheers
>
> Andy

You cannot create indexes on views since they are "logical" objects - as opposed to "physical" objects (i.e tables). If a view is used in a query, Oracle will use the tables (and indexes on those tables, if necessary) underlying the view.--
hope this helps !
Srini
(to reply, change "nospam" to "chavali" in my email address. :-) ) Received on Mon Feb 16 1998 - 00:00:00 CST