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.

Regards,


Ann