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
- 7607 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 is view? Different types of view.
how to create view in bdc..??
What is dynamic action? : sap abap hr
how to Implement a BADI in which it restricts the access when purchase order is created against contract using definition ME_PURCHDOC_POSTED. please tell me the answers if any one knows. thanks in advance. :ravikiran
What is the use of program rsbdcsub? : abap bdc
How to copy table across clients?
What is going life actually? What is the role of a functional consultant in it? : sap abap hr
What is the difference between scrolling a table horizontally and vertically?
What is exception class and test class. How to use it?
Explain what is step-loop? Explain all the steps?
What is the disadvantage of a call by reference? : abap modularization
What is screen flow logic? What are the sections in it?
What is the tcode to create indexes?
What is the difference between abap and hr abap? : abap hr
Suppose the client wants me the vacancy to be displayed on a website as well as ess. How should I do it? : sap abap hr
