| Subject | Understanding a PLAN |
|---|---|
| Author | Jaume Llunell Gómez |
| Post date | 2014-08-30T07:25:45Z |
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
FROM TABLE1
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.
Jaume