Hallo,
Il 13/10/2017 21.33, 'Daniel Miller' [email protected]
[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
--------------------------
