what is the role of secondary index in performance?
- 1 Answers
- 16116 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
The loop-endloop on extract datasets can be used without any kind of errors. State true or false. : abap modularization
I created a field and entered the field type, when I double clicked the field type to define the domain; it is asking for an ACCESS KEY, I am not changing any SAP defined tables, working on a user defined table.
Can there be more than 1 main window in sap script?
What is the use of info groups? : sap abap hr
What are the attributes of the data? : abap data dictionary
What is dialog module?
Filter badi and multiple used badi? Will the sequence matter of the badi implementation in case of multiple used badi?
What is generic area buffering in abap?
Can you create a table with fields not referring to data elements? : abap data dictionary
Persistent class
How will you find manager of an employee
What is logo in sap script?
What are the types of indexes in abap?
Print options in smartforms?
How can we use / display table in a screen?
