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
- 8841 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 are the different database integrities?
What does the insert statement in extract datasets do?
how do you transport lsmw data from one system to another?
What is the bapi?
Can there be more than 1 main window in sap script?
What are indexes? : sap abap data dictionary
what is 3 tire architecture and how does SAP utilizes this architecture. and how do netweaver came into picture?
When a program is created and need to be transported to prodn does selection texts always go with it? If not how do you make sure? Can you change the cts entries? How do you do it?
How can one distinguish between different kinds of parameters? : abap modularization
What is logo in sap script?
Give Some examples of reports generated in real time scenarion? Also give examples of standard reports in SAP used in real time?
What are the types of records that are transferred to sap r/3 and used by interfaces? : abap bdc
How do you execute the payroll
Does the external program run in the same sap luw as the caller, or in a separate one?
Define infotype ? : abap hr
