02-09-2010 10:36 AM
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
02-12-2010 7:44 PM
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
02-09-2010 2:25 PM
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.
02-10-2010 10:34 AM
02-10-2010 11:03 AM
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
02-10-2010 11:06 AM
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
02-10-2010 11:19 AM
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
02-10-2010 4:42 PM
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.
02-12-2010 7:08 PM
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?
02-12-2010 7:44 PM
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