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
- 8951 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
Explain read dataset in sap abap?
Explain the differences between sap memory and abap memory?
Which infotype records can not be deleted ? : abap hr
Program lines for the radio button selection and unabling some input variables in section screen
Define subtype ? : abap hr
Explain what is sap script? What is the purpose of sap script?
Will 50,000 records be uploaded directly into APP's Server?
How can you access the function code from menu painter?
Explain the disadvantages of logical databases?
What are the data types of the abap/4 layer?
How do you display a data in a detail list?
How does the interface between the dynpro and the abap/4 modules take place?
What are the two levels in defining a match code? : abap data dictionary
What is the use of message command in a report? What are the different message types?
What is meant by authorization? Did you ever work on it? : sap abap hr
