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
- 8801 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 does an exec sql statement do in abap?
Differentiate between the uline and write: sy-uline statements if any?
Is it possible to pass data to and from include programs explicitly?
In sap script how to print bar code in vertical manner
Have you set up a back ground job? How to create a background job without a variant ? : abap bdc
What is the abap program name to process the batch input session automatically? : abap bdc
What is constructor expression in nw abap 7.4?
What is a batch input session? : abap hr
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?
What is sap script? Describe its components.
How are BAPI different from normal function modules?
How to Raise a Particular Ticket in Realtime ?
What will you code in start-of-selection & end-of-selecton & why?
What are the other modules integrated with om? : sap abap hr
hi experts,,, what is meant by documentation? test casr preparation? documentation and preparation and Tcode for this? quality and releasing? test case scenario?
