Skip to Content
0
Former Member
Apr 18, 2014 at 07:42 AM

Secondary index not getting picked

1007 Views

Hello All,

I am seeing stange behaviour of picking of secondary indexes.

Example:

Index - I1 is having two fields and the same two fields in giving in where clause of the select and this fields are unque and not used in any other secondary index.

Result in trace(ST05) -- Index I1 is not picked and it extraction went for 'Full table scan'.

But in other system for the same inputs index I1 is picked and it can be seen trace(ST05).

Before posting this query, i have gone through many posts related secondary index and not found helpful.

Any inputs will be appreciated.

Thanks.

Adnan.