Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / shreeshaildiggi
Indexes - What are they and how can I use them?
An index helps to speed up selection from the database. An
index is a sorted copy of selected database table fields.
The primary index is always automatically created in an
ABAP-based SAP system. It consists of the primary key
fields of the database table. This means, for each
combination of the index fields exists a maximum of one
record in the table. This kind of index is called a UNIQUE
index.
If the primary index cannot be used to determine selection
result, (for example, the WHERE condition does not contain
any primary index fields), the system searches the whole
table. To prevent this, and determine the selection result
by searching through a restricted number of database
records, you can create a secondary index.
However, you should not define an index for all possible
fields in the WHERE condition.
Creating a secondary index :
You can use the transaction ABAP Dictionary Change →
Indexes... → Create to create an index. To make the index
unique, select UNIQUE. To specify the fields that will
comprise the index, choose "Choose fields". Then save and
activate the index.
Optimal number of indexes for a table :
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.
Thank's and Regards
Shreeshail Diggi
SAP Technical Consultant Infinite India
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What are subroutines? : abap modularization
What is pretty printer?
How will you insert record in a sorted table
What is Buffering Concept? When should a Table be buffered?
What is the use of table maintenance allowed?
Workbench request are client dependent or client independent
ALV Report that will show the details of order like order no, order date, customer, product code & description, order quantity and value along with the details of dispatch of those orders like invoice no, invoice date, invoice quantity and pending order quantity. plz mention the detail coding Tahnks, Rahul
How can we declare a table control in the abap/4 program?
What is a type-pool?
How to combine multiple billing into one RV document ( Step by Step)?
I just wanted to know that when I am recruiting somebody, I am generating his personal no also. Then I want to give him training also. Now I just want to create 2 scenarios to clear my doubts? : sap abap hr
Can matchcode object contain ids with different update types? : abap data dictionary
Is logo in script 1st stored as tiff format before uploading or in jpeg format?and where is that stored after uploading?
Can i Have Some Examples on Enhancements.
hi I am in training of functional module, i am unable to understand what exactly use of IDOC,BAPI,DIM and BIM. As LSMW and BDC methods are used for data conversion from legacy to sap. Might be it is silly question. please explain me
