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