Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 8847 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
Which commands are used for interactive reports?
Explain what are the events in screen programming?
2)In production what is the user exit?
What is exception class and test class. How to use it?
What are domains and data element? : abap hr
Module Pool Programming: Events and Table Control handling.
What are the control break events in abap? : abap data dictionary
What are the different methods of bdc? : abap bdc
Describe the difference between macro and subroutine?
What are the differences between a database index and a match code? : abap data dictionary
How can we achieve MVC ?
Which function module would you use to check the user’s authorization to access files before opening a file?
What is Buffering Concept? When should a Table be buffered?
What are datasets in abap?
What is an abap/4 query? : abap hr
