Subject Re: [firebird-support] Question about optimization on views with agregate queries
Author Alexandre Benson Smith
Hi Arno,

Arno Brinkman wrote:

>Hi Alexandre,
>Yes, you can read that Firebird will put the condition into the HAVING
>clause and thus be performed after the aggregation. Why the HAVING clause?
>Because you could use a aggregate-function from the VIEW and that cannot be
>translated to the WHERE clause and must be in the HAVING clause. This is 1
>of the optimalizations that need to be done in the optimizer.
>Arno Brinkman

Understood !

Thank you Arno !

see you !


Alexandre Benson Smith
THOR Software e Comercial Ltda.
Santo Andre - Sao Paulo - Brazil