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?
Choices:
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
Info: Can someone explain in detail why this happened? It
will be really helpful to handle to case in Secondary index:
- 2 Answers
- 7620 Views
- SAP Labs, I also Faced
- E-Mail Answers
Answer Posted / vkbpl6012
In my opinion, the correct answer is
E: NE invalidates the use of an index
| Is This Answer Correct ? | 10 Yes | 1 No |
Post New Answer View All Answers
What are the different types of locks? : abap data dictionary
What are the different functions used in sap script? What are the parameters used in each function?
suppose i want to print sap script output in different printers at a time what are the settings i'll have to make?
What are differences between at selection-screen and at selection-screen output?
How do you write manual bdc session method? : abap bdc
What is the difference between upload and ws_upload ? : abap bdc
how to track records from data dictionary?
What are the functional modules used in sequence in bdc? : abap bdc
How to determine the attributes of an internal table?
Differentiate between ooabap and abap?
What are indexes? : sap abap data dictionary
What is the function of the transport system and workbench organizer?
What are the differences between interactive and drill down reports?
what are the main technical differences between oracle and sap? it would be more helpful to me if get this answer...
From Excel to ABAP - Is batch mode possible ?
