There is a select statement on a Ztable which has only one Key Field. Believe me the table is very huge. The fields used in the where clause are all Non-Key fields & the key fields can't be used as per the requirement.
In this case secondary index are created but it doesn't cover all the fields used in the select query.
My Qus:
1. Should all the fields used in the select should be specified in the same order in the index.
2. If one field is omitted in the secondary index will it affect performance.