Interested to Buy Any Domain ? << Click Here >> for more details...
what is the role of secondary index in performance?
- 1 Answers
- 16678 Views
- IBM, Siemens, I also Faced
- E-Mail Answers
Answer Posted / rohit
If you cannot use the primary index to determine the result
set because, for example, none of the fields primary index
occur in the WHERE or HAVING clause, the system searches
through the entire table (full table scan). For this case,
you can create secondary indexes, which can restrict the
number of table entries searched to form the result set.
You should only create secondary indexes, for database
tables from which you mainly read, since indexes have to be
updated each time the database table is changed. secondary
indexes should contain columns that you use frequently in a
selection, and that are as highly selective as possible to
improve performance..
| Is This Answer Correct ? | 17 Yes | 5 No |
Post New Answer View All Answers
What work you have done in HR module
If I want to execute a bdc program only in background not in foreground is there any option for this? : abap bdc
What is a bsp application? : sap abap hr
What is check table?
can anyone do BDC or BAPI for F-02 and F-04 transactions.If it LSMW also.Kindly let me know.
What is step-loop? Explain all the steps?
How we can retrieve data using secondary index. Explain with simple example?
What are the Control levels in internal tables?
What is the Process to transfer IDOC from Outbound System to Inbound system.
what will happen if called program is not executable ?
How do you Export a session ?
What are table clusters?
What are the different control break statements available inside a loop?
What are the attributes of a field that can be activated or deactivated during runtime?
Some Realtime Examples on Exits .
