11-21-2007 7:06 AM
Can someone tell me as to how we can transport the secondary Indices??
Please help.
11-21-2007 7:09 AM
Hi
Primary index : Its the index which is automatically created for the PRIMARY KEY FIELD(S) of the table.
The primary index is always created automatically in the R/3 System. It consists of the primary key fields of the database table. This means that for each combination of fields in the index, there is a maximum of one line in the table. This kind of index is also known as UNIQUE.
Secondary index : Its created as and when required,
based upon other field(s) of the table,
on which search criteria is used in sqls.
Secondary indexes should contain columns that you use frequently in a selection, and that are as highly selective as possible. The fewer table entries that can be selected by a certain column, the higher that columns selectivity. Place the most selective fields at the beginning of the index. Your secondary index should be so selective that each index entry corresponds to at most five percent of the table entries. If this is not the case, it is not worth creating the index. You should also avoid creating indexes for fields that are not always filled, where their value is initial for most entries in the table.
CREATION
go to SE11
enter table name
press display
from menu GOTO-> indexes
press create button
enter the fields for which you need the index
save and activate
use those fields in the Where condition of the select statement and see
Regards
Anji
11-21-2007 7:10 AM
Hi,
Create Transport request for that n transport it through se09/se01.
Rewar Points.......
Regards,
Prashant
11-21-2007 7:15 AM
11-21-2007 7:19 AM
Hi,
WHile creating Secondary index save it in Transport request n transport that request.
Regards,
Prashant
11-22-2007 6:38 AM
hey,
You must NOT to create indexes (nor anything) via your DBMS.
Delete old Index in dev box and re create it.
now activate it and also use activate and save database utilitlity( SE14) Transaction.
Now transport it.