Hallo,

Il 13/10/2017 21.33, 'Daniel Miller' dmiller@... [firebird-support] ha scritto:

 

>
It would be interesting to compare the plans for both your original
query syntax and Set's suggestion - see where the difference is.

Original:

PLAN (PNC2 NATURAL)
PLAN JOIN (PNC NATURAL, PNT INDEX (PN_TESTA_PK), C INDEX (PK_CLIENTI), 
PNS INDEX (PN_SCADENZE_FK))

With Set suggestion:

PLAN (PNC2 NATURAL)
PLAN JOIN (PNC NATURAL, PNT INDEX (PN_TESTA_PK), C INDEX (PK_CLIENTI), 
PNS INDEX (PN_SCADENZE_FK))

Thanks.

--

Luigi Siciliano
--------------------------