[firebird-support] Understanding a PLAN

[Jaume Llunell Gómez jaumellun...@gmail.com [firebird-support]]

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