Answer / 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

Answer / paramjeet

Indexes are described as a copy of a database table reduced
to specific fields. This data exists in sorted form. This
sorting form ease fast access to the field of the tables. In
order that other fields are also read, a pointer to the
associated record of the actual table are included in the
index. the indexes are activated along with the table and
are created automatically with it in the database.

What event is trigger wen screen is displayed?Before displaying Initailization and Pressing enter At selection- Screen..............But at the selection displayed and we are entering values naa that time?

1 Answers   Bosch,

---

How many rediobutton groups can be there in a module pool program and in a report?

2 Answers   BOC, BPCL Bharat Petroleum,

---

what is bdc?

6 Answers   TCS,

---

I have developed a program where i have used Ranges and the program is running fine in DEV and Quality server but as soon as it goes to Prod server it shows some errors.What can be done in this case??

6 Answers   IBM,

---

What is the mandatory event in LDBs.

2 Answers  

---

What does the ‘suppress dialog’ do?

0 Answers  

---

1/ what r the parameter used in alv report ?

0 Answers   DataMetrix,

---

what is the process of dialog program from first to last?

3 Answers   Intelligroup,

---

can i use table key and key in an internal table and explain the functionalities of each one and what functionality does it give if both are used for same internal table

0 Answers   Wipro,

---

in real time with the help of scripts what we can do?

2 Answers   CSC, Google,

---

What does a lock object involve?

0 Answers  

---

What are MENUEXITS, SCREENEXITS, FUNCTIONEXITS, FIELDEXITS and what is the difference between them ?

3 Answers  

---