We have this table:

Sel Name Owner T DB Name TS Name Cols Rows * * * * * * * *
----- ------------------ -------- - -------- -------- ------ ----------- * TABLAEXE TACX T DBTABLAX TSTABLAX 29 118


… with these Ixs :
Index Table C C C
Select Index Name Owner Table Name Owner U Cols G D L T
* * * * * * * * * *
------ ------------------ -------- ------------------ -------- - ------ - -
XABLAEXE TACX TABLAEXE TACX U 1 Y Y N 2
XABLAEX1 TACX TABLAEXE TACX D 1 N N N 2
XABLAEX2 TACX TABLAEXE TACX D 1 N N N 2


The Tspace has just been reorganized with RUNSTATS option.
When we do .. SELECT * FROM TACX.TABLAEXE, … we receive the rows ordered by index XABLAEX2.
Can anybody explain why the optimizer selects this Ix ?
Thanks in advance

What OS and DB2 version are you using. It would also help to see the DDL for the table and indexes. Also the distribution of the data with regard to the indexes would help.

Andy