Re: CREATING VIEWS

A view is only a database defined query, it does not contain any data: to select data from view is the same of execute a query on your three tables:
so you cannot create indexes on views, but you can create indexes only on
the tables on witch your view is created. Typically, with joins, you have to create indexes on the fields included in the
where condition. For more informations on indexing strategies, referes to
manuals.

Bye

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
Received on Sun Feb 22 1998 - 00:00:00 CET