Ok,

so for optimizer, a condition is the same wherever it comes from ?
Thank's

Thierry

Dimitry Sibiryakov a écrit :

>> In this case, putting test about year or quantity in join will not
>> produce a different result
>> But what about efficiency ?
>>
>
> In this case - no differences. Optimizer will gather all conditions
> into one pile.
>
> SY, SD.
>
>
> ------------------------------------
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://www.firebirdsql.org 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
>
>
>
>