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
- 7621 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
What is going life actually? What is the role of a functional consultant in it? : sap abap hr
What are the types of the software component being deployed in the sap?
Explain what is the significance of hide?
What are client dependant objects in abap/sap?
What is the significance of delivery class? : abap data dictionary
Define the various contents of technical specifications ?
How did you transfer legacy data in the mid of the financial year (us) to the sap system? : sap abap hr
Did you create secondary index?
How do you restrict the data to be entered in the payroll area? : sap abap hr
performance tuning concepts
Mention the various databases integrities?
What is ps structure? : abap hr
What are the two statements which are required in an abap program to output an icon using a write statement?
Hat are the different types of mode (run code) in call transaction method?
Is it possible to pass data to and from include programs explicitly?
