Thanks.
BTW, I know it's done when it's done, but does anyone have a SWAG on the
2.0 beta or final?

-----Original Message-----
From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of Ann W. Harrison
Sent: Tuesday, May 03, 2005 2:14 PM
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] Plans involving views

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



Visit http://firebird.sourceforge.net and click the Resources item on
the main (top) menu. Try Knowledgebase and FAQ links !

Also search the knowledgebases at http://www.ibphoenix.com Yahoo! Groups
Links