In a table TABLE_XY I defined an index with

CREATE INDEX_XY ON TABLE_XY (FIELDNAME_X,FIELDNAME_Y)

In my TIB_Query SQL statement I'm using

select * from table TABLE_XY order by FIELDNAME_X, FIELDNAME_Y

Do this statement use the defined index, or how should I say the TIB_Query
to use it?

Or am I totally wrong in what I'm doing...

Thanks in advance

Ulrich