Subject | Re: [firebird-support] Plan undestanding |
---|---|
Author | Jaume Llunell Gómez |
Post date | 2012-11-03T21:40:23Z |
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]
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]