At 12:36 PM 23-09-02 +0200, you wrote:

>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...

It looks OK to me, so far.... :)) Fb/IB will use your index to return your
ordered set.

In IBO, you can have multiple orderings on the same set, by telling IBO
about other indexes you have on columns in this set. Then the user can
reorder the items in an ib_grid by clicking on the column title. You can
define both ascending and descending orderings for the same column.

You don't name the indexes: it will be valid as long as the indexes
exist. See the documentation for OrderingItems.

Helen