kokok_kokok wrote:

> If I use INNER JOIN or I re-write the SQL statement using the
> underlying tables instead of the views (using LEFT OUTER), the results
> are displayed in seconds.
>
> Does somebody have a clue about this problem?

You probably have WHERE clause filtering on some column of LEFT joined
table, so FB doesn't use some of the indexes. Try comparing the plans of
those statements.

--
Milan Babuskov
http://njam.sourceforge.net
http://www.flamerobin.org