Rick Debay wrote:

> If I have a view that wraps an aggregate query, and query the view
> adding a where clause the plan doesn't use the available indexes and
> instead goes through the entire table.

That's a known restriction. Firebird2 has had a lot of work on the
optimizer, and it may handle views containing aggregates and group by
better than earlier versions.

Regards,


Ann