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
- 8950 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
ALV Report that will show the details of order like order no, order date, customer, product code & description, order quantity and value along with the details of dispatch of those orders like invoice no, invoice date, invoice quantity and pending order quantity. plz mention the detail coding Tahnks, Rahul
What is at exit-command:?
What is tcode se16? For what is it used.
What should be the approach for writing a bdc program? : abap bdc
What are match codes? describe?
singleton class
difference between Valuation type and valuation category?
How can we declare a table control in the abap/4 program?
What is sap luw or update transaction?
Do we have to migrate all sapscript forms to smart forms?
I need the coding for BDC program to upload Purchase orders of known vendor (ME21) in Material Management
What is the use of the statement leave to list-processing?
What is the difference between synchronous and asynchronous update? : abap bdc
Program lines for the radio button selection and unabling some input variables in section screen
what is leave to TRANSACTION?
