Answer / pratap

Secondary indexes should contain columns that you use frequently in a selection, and that are as highly selective as possible.

Only 9 Indexes allowed

from efficiency point of view only 5 can be created because
You should not create more than five indexes for any one

table because:

Whenever you change table fields that occur in the index,the index itself is also updated. The amount of data increases. The optimizer has too many chances to make mistakes by using the 'wrong' index.

If you are using more than one index for a database table,ensure that they do not overlap.

Answer / sriharsha

Try to research about db hints ,
this will table to use which secondary index as you should already know which index to use for your query.

problem is all DB's handle hints differenty, some dont bother about your hint

How to get the status of an IDOC in a report without using WE02 transaction ?

1 Answers  

---

Do you know how to manage the sequence of passes in a Form?

1 Answers  

---

how to navigate to report from report? note: no transaction code created to report.

1 Answers   IBM,

---

How To Debug Ale ....

3 Answers   Accenture,

---

Which database object is used for storing the system variables? : abap data dictionary

0 Answers  

---

Hi Experts, I faced the below questions in written exam, its simple only but i am not able to find the answer in Google also. Can any of our family ppls pls give the answer the below questions? 1.How many days once password will get expire? is it really in adminstrator hands or what? 2.SAP Logon Password length for ECC-6 and ECC-5 3.Which is the highest organizational level in SAP? Explain the various level of organizational structure in SAP? 4. You have one idoc, we need to send 3 different system. It will generate how many master idoc and how many communication idocs? 5.What is the default parameter in subroutne? call by value or call by refference? 6. Scope creep is responisible for what? 7.Who approves the project design? 8.When LUW will starts? 9.Which Website used for SAP support? 10.When a print request is not sent, which of the following is used to send the request again to the printer?..... a) print changes b) print directly c) both of the above d) none of the above 11. Its possible to transfer data into same client using ALE? 12. Customization changes are automatically stored in a Transport request or not? Explain 13 User id in SAP support system is called as what? a) Userid b). SAP userid c) S userid d) None of the above. 14. The sap for utilities is a. Program b) Function c) Approach d) Industry Solution 15.In Work flow whats the use of WF-BATCH?

2 Answers  

---

Can you print decimals in type n? What is difference between float and packed data type?

0 Answers  

---

Difference between Occurs0,occurs10 and occurs100?

4 Answers   HCL,

---

What will you code in start-of-selection & end-of-selection ?

0 Answers  

---

How do you control printer functions from sapscript?

0 Answers  

---

What are the two statements which are required in an abap program to output an icon using a write statement?

0 Answers  

---

What all are the differences did you find in hr module between 4.7 and ECC6 versions

0 Answers  

---