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
- 8800 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 does an exec sql statement do in abap? What is the disadvantage of using it?
when are objects are passed from task to the change request?
What are the two different ways of building a match code object? : abap data dictionary
What are logical databases? What are the advantages of logical databases?
after creating lock object if does n't access record by second user what should we do?
How many types of tables exists and what are they in data dictionary? : abap data dictionary
What is the functionality of BIZTALK and how it handles the IDOC’s and how u will transfer the IDOCS to the BIZTALK ?
What is meant by slab? How is indian slab and us slab? : sap abap hr
What is modularization and its benefits?
How can you manipulate the presentation and attributes of interactive lists?
What are screen painter and menu painter? : abap hr
Select up to 1 row and select single difference ?
What is table pool?
What are the differences between structure and table in data dictionary in abap? : sap abap data dictionary
Explain lsmw?
