Subject Re: [Firebird-general] OpenCRX DBMS comparison
Author Ann W. Harrison
Martijn Tonies wrote:
> I also know that the optimizing of a statement that included a view is,
> well, sub-optimal. :-)

I think you'll find that the views that are problematic views all have
aggregates, distinct, or group by. Not an excuse, but a clarification
for the naive. A simple view should be optimized well. A view that
compresses data will be materialized first, then integrated with the
rest of the query.