Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Index usage

Table ztest has a secondary index on the following fields:

tnum, tcode.

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,

Lohit

Tags:
replied

Hi,

Answer is option c & e.

Regards,

Amit

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question