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 |
Explain what are the system fields? Explain?
What's the use of AT PF event?
What is roll area?
What is schema and transaction code
Do you know any other patterns if yes.. explain
HOW TO CREATE INDEXES IN TABLES?
There is one scenario , where A Badi consists of multiple implementations ,and i need to execute only PERTICULAR implementaion (say 2nd ) , ONLY One implementation , then how can execute the perticular implementation .
Explain what are the events in screen programming?
What are standard layouts sets in the sap script?
we will create functionmodules in real time or reusing exsiting one's in abap and webdynpro abap?
What are screen painter and menu painter?
i am new for sapabap. i want to about sapabap it is easy to learn or not ple give me answer. i am feeling about programing. ple give me answer.