Re: Indexing a view
Date: Mon, 23 Sep 2002 23:05:02 +0200
Message-ID: <1mLj9.2090$EM5.71227_at_news.siol.net>
Analyse the query on which the view is based on and determine if it is possible to rewrite it with better query response times, or if adding additional indexes on tables, which the view is querying might help. You can not add an index to a view, but you can to tables.
_make_database_faster=true
won't work :)
Best regards,
Ognjen Antonic - Ogo
"Anand" <ashrivastava_at_auriga-insys.com> wrote in message
news:396cc940.0209120149.2c5f0a9c_at_posting.google.com...
> Hi,
>
> Even I have a similar problem. I've a view that is based upon just two
> tables but has more than 60 fields and approximately 400,000 records.
> However I can not opt for materialized views. I've already created
> index on some of the fields that are often accessed. Any other
> suggestions how can I speed up the performance?
>
> Regards,
> Anand
Received on Mon Sep 23 2002 - 23:05:02 CEST