Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

Secondary Indexes

Former Member
0 Kudos

Hi Everybody

Is thr any limit on creating number of secondary indexes on any database table??

Thanks

4 REPLIES 4

venkata_ramisetti
Active Contributor
0 Kudos

Hi Rashmi,

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.

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

Tahnk you,

Ramakrishna

Message was edited by: Ramakrishna Prasad

Former Member
0 Kudos

Hi Rashmi,

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
0 Kudos

Hi,

As mentioned by Sekhar we can atmost create 9 secondary indexes.

Thanks and Regards,

Bharat Kumar Reddy.V

0 Kudos

Hi Rashmi,

It is possible for us to create only 9 secondary indexes greater than this is not possible.

Regards,

Santosh