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:
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / vkbpl6012
In my opinion, the correct answer is
E: NE invalidates the use of an index
Is This Answer Correct ? | 10 Yes | 1 No |
if i want to insert 10 laks MM records and for inserting one record it takes 1 min by using call transaction or session method . so here is there any alternative
What is difference between BDC and Call Transaction?
How to execute a smart form?
How do you use tab sets in layout sets?
in which situation we use user-exits and badi's?? with example
Persistent class
what is was server in sap
my questions are (1) how to transport a table along with its data from dev to prod/qa server? pls reply elaborately. if possible with screen shots. (2) i want to display like this :- * ** *** ****
What are the functional areas? User groups? And how does abap/4 query work in relation to these?
Pls someone answer me this, Can we acheive everything using OOPs? If not? What cant be acheived? Have you encountered any scenario liike, you cannot acheive it using Function modules & can be acheived using Oops? What is the advantage of BADI over UserExit? Difference between BAPI and RFC? Thanks in advance.
Is sap xi intended to replace ale?
Explain the differences between se01, se09 and se10?