Svein Erling Tysvaer wrote:

>>The plan is NATURAL for both tables. In the database we migrated from
>>MSSQL those tables have millions of records.
>>
> Have you considered triggers, Milan? I.e. have a table populated through
> triggers on table1 and table2 rather than a view. Sure, it is a
> workaround of a problem soon to be solved anyway, but unless there are
> problems with the table size

As you can see we talk about millions of records.

> it should be a lot simpler than writing
> hundreds of procedures and indexes will be no trouble.

Currently we do a daily backup, restore database to other server, create
an empty tables that we same structure as views and do:

insert into empty_table
select * from complex_view;

create indexes on empty_table;

And we re-route reports to that other server.

--
Milan Babuskov
http://swoes.blogspot.com/
http://www.flamerobin.org