topic Re: indexes in Application Development and Automation Discussions

indexes

Former Member — Thu, 08 Mar 2007 11:38:27 GMT

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

Re: indexes

Former Member — Thu, 08 Mar 2007 11:39:25 GMT

Hi,

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

Regards,

Anji

Re: indexes

Former Member — Thu, 08 Mar 2007 11:39:31 GMT

Hi Sonyia,

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

Regards, Dieter

Reward points if usefull

Re: indexes

Former Member — Thu, 08 Mar 2007 11:42:16 GMT

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

Re: indexes

seshatalpasai_madala — Thu, 08 Mar 2007 11:45:08 GMT

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

Re: indexes

Former Member — Thu, 08 Mar 2007 11:46:59 GMT

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

Re: indexes

Former Member — Thu, 08 Mar 2007 11:58:44 GMT

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

Re: indexes

Former Member — Thu, 08 Mar 2007 12:33:18 GMT

max number of sec indexes is limited to 9 .

plz check ur answer.

vijay