Skip to Content
avatar image
Former Member

Maximum Number of Seconday index on ECC6.00

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

7 Answers

  • Best Answer
    avatar image
    Former Member
    Feb 12, 2010 at 07: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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 09, 2010 at 02: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.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 10, 2010 at 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

    Add comment
    10|10000 characters needed characters exceeded

    • 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

  • Feb 10, 2010 at 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

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 10, 2010 at 10:34 AM

    Hi,

    Maximum number of secondary indexes are 9.

    Thanks,

    Abhijit

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 10, 2010 at 04: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.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 12, 2010 at 07: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?

    Add comment
    10|10000 characters needed characters exceeded