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
- 8762 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 are the different types of internal table?
What is the transaction for recording bdc ? : abap bdc
Can we create an abap program without using y or z?
What is a table cluster? : abap data dictionary
What is step-loop?
Difference between BDC vs Direct Loads?
suppose i want to print sap script output in different printers at a time what are the settings i'll have to make?
What is the last entry in all bdc tables? : abap bdc
What is ps structure? : abap hr
How many types of size categories and data classes are there? : abap data dictionary
What are base tables of an aggregate object?
What are the functional areas, user groups? How does abap query work in relation to these?
How to do find it?
What is the significance of delivery class? : abap data dictionary
Difference between Insert, Update and Modify?
