Can someone explain why DB2 is selecting one index over another. We are using DB2 9.7 on AIX.
CREATE INDEX INDEX1
CREATE INDEX INDEX2
Select * from spec_test where acc_num = '1234567' and acc_num_yr = 2014 and tst_seqnum = 4;
When I look at Visual Explain, DB2 is selecting INDEX1 over the exact match of INDEX2 .
Now, here's what makes it even stranger, this is only happening at a couple of client sites, others are working as expected.