Re: Indexing a view

ashrivastava_at_auriga-insys.com (Anand) wrote in 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
>

Add to the initSID.ora file the undocumented parameter below:

_make_database_faster=true Received on Thu Sep 12 2002 - 14:12:28 CEST