Maximum Number of Seconday index on ECC6.00

[Former Member]

Hi all,

I tried created 22 seconday indexes for a table in ECC6.00 . This was just for testing purpose. Can anyone tell me the limit on number of seconday index on SAP table.

I searched forums before posting and found that 15 is the max limit.

Best Regards

Hari

[christine_evans]

I don't think there is a maximum as far as the database is concerned. Though there certainly would be a maximum as far as common sense and the number of indexes you really need is concerned. If you've managed to exceed 15 then we can conclude that that was the wrong answer.

[Abhijit74]

Hi,

Maximum number of secondary indexes are 9.

Thanks,

Abhijit

[Former Member]

Abhijit,

I myself created 22 secondary indexes on ECC6.00 transparent table. Please let me know if you have tired and found that only 9 secondary indexes can be created/.

Best Regards

Hari

[Former Member]

Hi

I don't think there's a limit of a number of indexes can be created, but there's a limit in tablespace for the space can be used for it

Max

[P561888]

Hi ,

There is no limit for the Secondary index, but we should be carefull not to repeat the fields ... Performnace optimizer will not identifies the correct index ...

Reagrds,

Bharani

[Former Member]

I heard long back that max secondary indexes are 9, but i dont think so since i could not see any specific number in the sap help. So looks like there is no restriction. But less no will be always productive.

[Former Member]

SAP Guidelines are no more than 5, but that's not the max of course...bigger concern...what will large number of indices do to run time when data is saved, and will the extra indices 'confuse' the db optimizer and end up using the wrong index in SAP standard transactions?

[Former Member]

Bear in mind that standard SAP table DIFT_POS_IDENT has 23 indexes (17 of which exist in the database). But it has only 22 fields!

Rob