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
- 8712 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
Explain the client concept of sap.
Differentiate between the uline and write: sy-uline statements if any?
If I have put commit in badi implementation class after update, is it allowed? Also if some standard functionality already implemented an update and now i m doing update and if it fails, what will be the impact of commit?
Can a domain, assigned to a data element be changed?
What is the Process to transfer IDOC from Outbound System to Inbound system.
What are the sequences of event block?
What are the events driven batch jobs?
What should be the approach for writing a bdc program? : abap bdc
Explain the differences between at selection-screen and at selection-screen output?
while implementing badi what are the tables u find??
What is the use of the raising exception?
Define dispatcher?
what is mean be On Change of in Control Break statement
What is maintenance view?
Where the payroll results are stored
