|Subject||Understanding a PLAN|
|Author||Jaume Llunell Gómez|
Hi, i would like to understand this plan
PLAN (TABLE1 ORDER TABLE1_IDX1 INDEX (TABLE1_UK))
And the select that generets it is this one:
SELECT first 1 PREU_COST
WHERE ARTICLE = :p_article
AND DATA <= :P_DATA
AND DIVISA = :P_DIVISA
AND PREU_COST >0
ORDER BY DATA DESC,ID DESC
So my question is, does this plan first goes to TABLE1_IDX1 to resolve the order by or first uses TABLE1_UK to resolve the where?
Thank you very much.