Indexes

[Former Member]

How many indexes can be created for a table?

Regards,

pandu.

[Former Member]

An index is a copy of a database table that is reduced to certain fields. This copy is always in sorted form. Sorting provides faster access to the data records of the table, for example, when using a binary search. A table has a primary index and a secondary index. The primary index consists of the key fields of the table and is automatically created in the database along with the table. You can also create further indexes on a table in the Java Dictionary. These are called secondary indexes. This is necessary if the table is frequently accessed in a way that does not take advantage of the primary index. Different indexes for the same table are distinguished from one another by a separate index name. The index name must be unique. Whether or not an index is used to access a particular table, is decided by the database system optimizer. This means that an index might improve performance only with certain database systems. You specify if the index should be used on certain database systems in the index definition. Indexes for a table are created when the table is created (provided that the table is not excluded for the database system in the index definition). If the index fields represent the primary keys of the table, that is, if they already uniquely identify each record of the table, the index is referred to as an unique index.

<b>It comes with one primary index and any number of secondaary indexes can be created at the cost of the performance of you DB!</b>

regards,

srinivas

<b>*reward for useful answers*</b>

[Former Member]

I think there is no restriction on how many indices you create.....

But the thing is the database performance will degrade if u create index after a certain no.

[Former Member]

Hi,

Primary indexes are existing indexes we can use directly those indexes. we need to create the secondary indexes. In tables we will use both primary and secondary indexes.

Create secondary indexes step by step procedure.

1. Secondary index is created to enhance the performance. If you create wrongly defined index, it will decreases the performance.

Follow the below steps to create secondary index.

A.Go to t_code (se11) display your table name.

B.To create new index, click on index button on tool bar.

C.Give the index name.

D.Pass short text description for your index.

E.Bottom of the table pass field names on which you want index.

F.Save and activate.

2. You can create up to 16 indexes. But 5 is recommended...

Reward points if useful.

Thanks & Regards,

Vasudeva Rao

[Former Member]

Hi,

U can create maxium of 15 secondary indexes for a tabel.

Primary index will be created automatically based on primary key when u activate the table.

reward points if it is helpful.

Regards,

Satish.

[former_member235056]

Hi frend,

Max upto 16 indexes can be created but SAP recommends only 5 to create.

Regards,

Ameet