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
- 8713 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 is a table pool? : abap data dictionary
What has to be done to the packed fields before submitting to a BDC session.
What is full form of bdc session? : abap bdc
What is the symbol to do “concatenation” operation in nw abap 7.4 ?
What are the aggregate objects in the data dictionary? : abap data dictionary
What are the uses of table pool or table cluster.
What are the attributes of a field that can be activated or deactivated during runtime?
Does the bdc-insert function allow multiple transactions to be processed by sap? : abap bdc
What are conversion & interface programs in sap?
What is projection view?
What is dynamic action? : sap abap hr
What is the syntax of packed number?
What are the events in classical reports?
What are lock objects?
What does an EXEC SQL stmt do in ABAP? What is the disadvantage of using it?
