05-06-2006 6:01 AM
Hi Everybody
Is thr any limit on creating number of secondary indexes on any database table??
Thanks
05-06-2006 6:30 AM
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
05-06-2006 6:37 AM
Hi Rashmi,
Maximun number of indexes for a table can be 9 , so there is a limit for that
check this FAQ
05-06-2006 7:20 AM
Hi,
As mentioned by Sekhar we can atmost create 9 secondary indexes.
Thanks and Regards,
Bharat Kumar Reddy.V
05-06-2006 9:43 AM
Hi Rashmi,
It is possible for us to create only 9 secondary indexes greater than this is not possible.
Regards,
Santosh