Juergen Bachsteffel wrote:
-----------------------------------------------------
An external programmer team developed a application for a
company I consult now. They needed some new features
and the programmers added two new VIEWs to the database.
Now the application tooks very long (30-60 sec) for startup,
because the VIEWS are used in the main window.
...
-----------------------------------------------------

Post the PLANs for the queries that use those views. Do check if there are
[reasonable] indexes defined (to support joins and WHERE clauses).
Is there a WHERE clause (in the queries)? How many records in the result set?


Regards,
Aage J.