Subject Re: Can this VIEW's be optimized?
Author Aage Johansen
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?

Aage J.