According to me the query should be able to pick up the index, but it dosent do it. because of this we have performance problem. There are around 80 million records in the table and for each partition we have around 8 million rows.
Other information are as follows:-
Cluster ratio of the index GWIX2761 is 100
Please help us why the query is not picking up the index?
Why would DB2 need to go to the index ? By going to the tablepart the where clause is resolved.
Because no extra criteria are given and the query is not index-only, it is better to do a table(part)scan.