Subject Re: [firebird-support] Plan undestanding
Author Jaume Llunell Gómez
Well i used wrong words then, i don't understand the description of the
query execution. I would like to understand to know why it performs slowly:

PLAN
JOIN(....)(CUSTOMERS INDEX (CUSTOMERS_PK))(PROCEDURE_1 NATURAL)(PROCEDURE_2
NATURAL)

What is done between the JOIN set, the CUSTOMERS set and the PROCEDUREs
sets. There is no operation with parenthesis surrounding them. So when the
join is finished i don't know what happens because there is no operation to
be executed with the others sets.

Thank you.


[Non-text portions of this message have been removed]