Interested to Buy Any Domain ? << Click Here >> for more details...
what is the role of secondary index in performance?
- 1 Answers
- 16686 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 are the advantages of different types of bdc's?
Is there any method apart from bdc for data upload to sap? : abap bdc
Exception handling and how does it transfer from called method to calling method?
What are the mandatory fields to be filled for BAPI_CUSTOMER_CREATEFROMDATA1
It is possible to assign a local data object defined in a subroutine or function module to a field group. State true or false. : abap modularization
how to Create reports in SD module such as sales order report, which covers all organization levels, delivery status, invoice status, shipping details and partner function details. The data will be extracted from VBAP, VBPA, VBAK, VBUP, VBFA, KNA1, LIPS, VBRP, MARA, VBEP and KONV tables. plz mention the detail coding Tahnks, Rahul
In which cluster time results are stored? : abap hr
Is main window mandatory in smartforms?
Explain about interactive report?
Difference between top-of-page and top-of-page during at line- selection?
what is 3 tire architecture and how does SAP utilizes this architecture. and how do netweaver came into picture?
What are dml commands in abap?
How to create a link between modified form and modified print program?
Can you set up background processing using call transaction?
What is the difference between synchronous and asynchronous update? : abap bdc
