Re: Indexing a view

No you can't make a index on a view, but you can do two other things, depending on what version of the database you are using.

First, this can be done on any database. Make a really god index on you table this way, the view should be faster.

The second one i the best, but it requires a newer version, I believe you need at least 8.1.6.0.0.
Instead of creating a view, create a materialized view. It's like a table, so you can make indexes on them, but you need to specify who to update the MW since it's not exatly like a view.

If you need more help, I will see if I can find some more info on MW fore you.

Regards
  Rene S. Nielsen

"Riyaz" <skriyaz_at_yahoo.com> skrev i en meddelelse news:8b59c056.0208161030.5506e02f_at_posting.google.com...
> Hi,
> Is there any way to index a VIEW.
>
> Thanks,
> Riyaz
Received on Fri Aug 16 2002 - 23:13:36 CEST