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:
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / vkbpl6012
In my opinion, the correct answer is
E: NE invalidates the use of an index
Is This Answer Correct ? | 10 Yes | 1 No |
Q : I want to see material details in secondary list based on material No. from basic list. I will double click on any row, any field of basic list (not on field containing material no.) & the secondary list will display material details according to material No. on that row. Is it possible? If so how?
What is the difference between data elements and domains? : abap data dictionary
What is view? Different types of view.
What are interactive reports?
what will happen if you don't give occurs clause while creating an internal table ?
In a script, i want to print something at end of last page only.How can i print it?
What is the transaction code to modify the hr form
How many domains will create for one data element?
Can i have some Realtime Scenarios on Reports.
can u create internal table dynamically ? how?
4 Answers Bristle Cone, Cap Gemini, HP, IBM, MetaMorph, Satyam, Wipro,
difference between report and module pool
i want to populate 10 fields in smartforms..uptil 9th it is taking but 10th one is not populating?what might be the reason?