Hi,

what's the difference between these two query plan:

1) PLAN JOIN (PRN00 NATURAL,ANA00 INDEX (PK_ANA00),PRN30 INDEX
(PK_PRN30),ART00 INDEX (PK_ART00),PRN20 INDEX (PK_PRN20),PRN10 INDEX
(PK_PRN10))

Elapsed time= 19.16 sec
Fetches = 1678210

and


2) PLAN JOIN (PRN00 NATURAL,PRN30 INDEX (PK_PRN30),ART00 INDEX
(PK_ART00),PRN10 INDEX (PK_PRN10),ANA00 INDEX (PK_ANA00),PRN20 INDEX
(PK_PRN20))

Elapsed time= 0.26 sec
Fetches = 18034


The result of these two SQL are the same, not the performance.


Ciao
L.