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
- 8303 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 is ole?
Can we use transfer dataset to transfer data in internal table ?
there are 2 selection screens. material num in screen 200 and plant in screen 300. so how can you write in INITIALISATION event?
Difference between sy-tabix and sy-index?
i want to add 2 records to a table but the last field in the table is 1000 char long.Is it possible?if yes how?
What are the names of the function modules that will be generated upon activation of a lock object?
What are the basic object types? : sap abap hr
What is an Open Item in SAP? How will you find an Open Item in SAP?
Explain what is a foreign key relationship? Explain this with the help of an example.
When value table becomes check table?
What are two methods of modifying sap standard tables?
What data is contained? : abap data dictionary
What are the different types joins?
What is Transactional based Application & Role based Application?
Hi to all abap gurus iam new to abap and my querry is as follows . and i feel so happy if u give exact anwers ? Querry1: i have one page( named "page1" )in my script with three windows(logo,adress,main windows) my requirement is to display some dynamic data in the script that is list of orders of the customer whn u give the customer number in selction-screen .then we can go for main window only to dispaly dynamic data ? or is there any other option ? then what should we give as apage number in the next page attribute in the header information. suppose if i dont give "page1" in the next page attribute as anext page what will happen ? i mean that dynamic data will be displayed or not ? Querry2: one one more querry incase if we have two pages in my layout .in page1 (3 windows as said above ) and page2 ( only logo and address window ) and no main window in page2. now if we give "page2" as next page in the next page attribute of page1 then that dynamic data will be displayed or not ?
