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 th
On 2-11-2012 11:09, Jaume Llunell Gómez wrote:
> 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*)*
> .
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 a