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
- 7612 Views
- SAP Labs, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What is the difference between open_form and close_form?
What is interactive reporting?
What is the use of info groups? : sap abap hr
List some of the many different ways that the sap standard functionality can be changed by a customer?
What are the 3 methods that we use in sequence in a batch input session method? : abap bdc
How do you backup Sapscript layout sets? Can you download and upload? How?
Can a constructor be redefined?
What is the tcode for sapscript forms?
What are the abap/4 commands that link to a layout set?
HOW CAN YOU USE A PAGE COUNT IN CALLING A PAGE IN SMARTFORM?
what are the problem we face during development( if we say v are in support(development)? what are the critical problems araises during LSMW updation and Smart form layout development for involce and po? very very important questions now a days commonly asking..plz plz reply me
Explain lsmw?
when u prefer lsmw?
What does a lock object involve?
What is the difference between rfc and bapi function modules? : abap bdc
