Skip to Content
0
Former Member
May 08, 2008 at 01:02 PM

Secondary Index.

27 Views

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.