Subject | Plan undestanding |
---|---|
Author | Jaume Llunell Gómez |
Post date | 2012-11-02T10:09:57Z |
Hi,
when i execute a long query with Firebird 2.5.2 with various LEFT JOIN to
procedures and i get a plan like this:
PLAN
JOIN *(* .... *)*
*(*CUSTOMERS INDEX (CUSTOMERS_PK)*)*
*(*PROCEDURE_1 NATURAL*)*
*(*PROCEDURE_2 NATURAL*)*
....
I don't undestand what kind of operation is executed between all the result
sets of this statements because after all the parenthesis is no comma and
there isn't any operation that surround all of them. So i don't undestand
how this plan is executed.
Can anybody help me.
Thank you very much.
[Non-text portions of this message have been removed]
when i execute a long query with Firebird 2.5.2 with various LEFT JOIN to
procedures and i get a plan like this:
PLAN
JOIN *(* .... *)*
*(*CUSTOMERS INDEX (CUSTOMERS_PK)*)*
*(*PROCEDURE_1 NATURAL*)*
*(*PROCEDURE_2 NATURAL*)*
....
I don't undestand what kind of operation is executed between all the result
sets of this statements because after all the parenthesis is no comma and
there isn't any operation that surround all of them. So i don't undestand
how this plan is executed.
Can anybody help me.
Thank you very much.
[Non-text portions of this message have been removed]