Interested to Buy Any Domain ? << Click Here >> for more details...
what is the role of secondary index in performance?
- 1 Answers
- 16796 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 is a database view? : abap data dictionary
wat is the default file name of BAPI trace?
What is abap dictionary or data dictionary? What is the transaction to access abap dictionary? : abap data dictionary
What is Buffering Concept? When should a Table be buffered?
what is diff between ECC 5.0 AND ECC 6.0
Does sap handle multiple currencies?
Setting up a BDC program where you find information from?
What are the different functions used in sap script?
What is match code? : sap abap hr
What are client dependant objects in abap/sap?
How to display if the value entered contains records or not?
In se11 -->Tech. settings --> Data class. If I save table as Mater data OR Transaction data, what effect will it has for 'Storage' in Database after activation. or In Database how it will store in both the cases.
PLEASE HELP ANYONE ON THIS ISSUE,is there any problem with this function module :RHPQ_T77BX_ADD_QUALIS_OF_DPLAN. IT IS TRIGGERING BEFORE COMPLETION OF THE DEVELOPMENT PLAN but it has to trigger after compltion of development plan..this issue raised in my project..so reply urgently..thanks in advance..
Can we include customizing include or an append structure with pooled or cluster tables?
What are the mandatory fields to be filled for BAPI_CUSTOMER_CREATEFROMDATA1
