I have a query in Db2 index concept.
Lets say table XYZ has A to Z columns.
& let's assume table XYZ has two index.
First index is for A & B column.
Second index is for A,B,E column.
When my SQL query refers to this table XYZ, which index would be referred. Whether it depends on fields given on "Where clause" ?
Thanks in advance.