Re: Beasty View

If you have Oracle8i you can use materialized views with query rewrite

Adrian Simpson wrote:
>
> I have a view that selcts from 4 tables and 1 view. The size of the tables
> range from 300,000 rows to 6.5 million rows. This figure will grow each
> week. At the moment it takes over twelve hours to get it's act together and
> start selecting the rows. It runs on a server that has heaps of grunt so
> that should not be a problem.
>
> Apart from optimising it so that it uses all of the indexes in all of the
> tables (which we are doing at the moment) is there any other suggestions out
> there, anything we are forgetting and should be doing?
>
> Cheers
> Adrian.
Received on Thu Jun 24 1999 - 07:13:43 CDT