Table ztest has a secondary index on the following fields:
Select * from ztest where tnum ne '123' and tcode = '456'.
Why is the index not used in the above case?
a) Indexes are not allowed on Z tables
b) Variables must be used, NOT literals
c) Select individual fields, not select *
d) Client is not in the where clause
e) NE invalidates the use of an index
Can you help me? Is it option a)?
Thanks & Regards,
Answer is option c & e.