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:
Answers were Sorted based on User's Feedback
Answer / shatanjay
Correct Answer Is : " E ".
Reason(s) : Negation (In this case 'NE') of Index fields
(in this case 'TNUM' will prevent DB Optimizer from
considering the field when searching for a suitable Index)
Is This Answer Correct ? | 11 Yes | 0 No |
Answer / vkbpl6012
In my opinion, the correct answer is
E: NE invalidates the use of an index
Is This Answer Correct ? | 10 Yes | 1 No |
How to handle error in session method? : abap bdc
what is the importance of macros? is it that it is useful only for addition or subtraction operation (arithmetic operations) ? I need more information regards this? I am waiting for the reply
What is sap abap data classes?
What is is a match code? : abap data dictionary
How can you manipulate the presentation and attributes of interactive lists?
What is BAPI ? & its used & functionality.
what is Work flow?
In an abap/4 program how do you access data that exists on a presentation server vs on an application server?
What is an update task? : abap modularization
What are the two ways of searching an ABAP Object and How to navigate to them
8) What are the compulsary values in RESUSE_LIST_DISPLAY and RESUSE_LIST_GRID?
What is step-loop?