Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2008
    Posts
    2

    Unanswered: Optimizer selects an Ix ...

    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

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •