Subject Re: [firebird-support] View takes longer than select, FB 1.5
Author Arno Brinkman

> I'm using FB 1.5. Both queries are identical, having identical WHERE
> and HAVING clauses.

As meantioned by Alexandre in FB1.5 the where clause on views which contain an aggregate query (or
union) is evaluated after the view is processed. FB2.0 will try (not always possible) to move the
where clause on the view into the where clause inside the view.

Arno Brinkman

General database development support:

Firebird open source database (based on IB-OE) with many SQL-99 features :

Support list for Firebird and Interbase users :

Nederlandse firebird nieuwsgroep :