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
Define external layer?
What is output determination?
Can we define our own match code id's for sap matchcodes ?
Why we are using Macros instead of Function Modules
Different types of locks?
Difference between sy-tabix and sy-index? Where it is used? Can you check sy-subrc after perform?
What are aggregated objects
How many types of tables exists and what are they in data dictionary? : abap data dictionary
how to update the filed value in SAP in ZAWSYS and create time and date? please tell me the answer
Explain what is an rdbms?
Hi every one ! You people are doing a great job here , Im going to attend Tata Technologies interivew on this sunday,Can anyone who has already attended this company interivew or other companies interivews in abap pls share ur experience with me and help me to get into job my id ushareddyabap@gmail.com. Thankyou verymcuh
In the MM module for finding out the standard cost what is the view one has to look at?
Explain the difference between domain and data element?
What are the basic objects of the data dictionary?
What are the function modules used in f4 help?
