Subject Re: [firebird-support] Views and left outer does not generate efficient plans
Author Milan Babuskov
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