indexes

[Former Member]

: how many indexes can be created for a table?could u plzz tell

[Former Member]

Hi,

Any number of Secondary Indexes can be created for a Table.

Regards,

Anji

[Former Member]

Hi Sonyia,

look here: http://help.sap.com/

Regards, Dieter

Reward points if usefull

[Former Member]

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.

award points if heipfull

with regards

jay

[seshatalpasai_madala]

Hi,

You can create a maximum of 15 indexes for a table but its not advised to create more than 5 and its advised to keep the number of fields also to 2-4.

More the indexes more the confusion for the query optimizer to decide on the index to chooose it can even worsen the performance so not more than 5 and better to keep them over few fields and use the proper WHERE clause as far as possible.

Regards,

Sesh

[Former Member]

Hi Soniya,

Indexes are generally used to improve performance. So we can go for 15 secondary indexes and a primary index but as the number increases the complexity of the program also increases.

So better go for the secondary indexes as less as possible, i,e, for a small number .

Hope this resolves your issue.

Reward well.

Regards

Message was edited by:

Raj

[Former Member]

<b>Maximum number of secondary indexes can be only 9</b>

[Former Member]

??

max number of sec indexes is limited to 9 .

plz check ur answer.

vijay