I use Firebird 1.5.4 and I have created some views joining several
tables in each view.

Views work fine and efficiently in statements like SELECT * FROM VIEW1.

The problem is when I use LEFT OUTER operator in 2 views, they query
takes several minutes in a large database.

For example:

SELECT * FROM VIEW1 LEFT OUTER JOIN VIEW2 ON ...



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?

Thank you