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.