secondary indexes

[Former Member]

Hi gurus,

I searched the forum for how many secondary indexes can we created? Some body telling 9 and some body telling 15. Which one is correct? Please clarify me

Thanks

Ravi

[Former Member]

Hi Ravi,

There can be a maximum of 15 Secondary indexes . but saying so it is better not to go for them . For an extent we can use a maximum of 2 or 3, if required as performance degradation occurs as no. of secondary indexes increases.

Hope this resolves your query.

Reward all the helpful answers.

Regards

[Former Member]

Hi....

there is no limitation on the number of secondary index...

Reward points if useful......

Suresh......

[Former Member]

Maximun number of indexes for a table can be 9 , so there is a limit for that

check this FAQ

http://www.sap-img.com/abap/important-abap-faq.htm

[Former Member]

Hi chandra..

I have seen this but i will not agree with you because i have created 19 indexes on a table in ECC 5 system. Just check it once...

Suresh......

[Former Member]

Hi Ravi,

There is no limit specified by SAP. But when we create more number of secondary indices, the system takes more times in choosing the proper index while executing the SELECT statement.

As per the SAP help..

Creating an additional index could also have side effects on the performance. This is because an index that was used successfully for selection might not be used any longer by the optimizer if the optimizer estimates (sometimes incorrectly) that the newly created index is more selective.

Check the below sap link for more details.

<b>http://help.sap.com/saphelp_nw04/helpdata/en/cf/21eb2d446011d189700000e8322d00/content.htm

https://forums.sdn.sap.com/click.jspa?searchID=728985&messageID=1884447

https://forums.sdn.sap.com/click.jspa?searchID=728985&messageID=1633228

http://www.sap-img.com/abap/important-abap-faq.htm

http://help.sap.com/saphelp_nw04/helpdata/en/80/1a6473e07211d2acb80000e829fbfe/content.htm</b>;

If it helps reward with points

Regards Rk

[Former Member]

hi

this is an excerpt from SAP Help file:

If a table has more than five indexes, you run the risk of the optimizer choosing the wrong one for a particular operation.

Regards,

madhu

[Former Member]

Hi,

Look at table ISSRFLDEA.

On our system it has 17 secondary indexes.

So neither 9 nor 15 is correct.

Or tables DIFT_POS_IDENT(17) or POGT_POS_GUARD(16).

Cannot find more than 17.

John