topic Re: secondary index in Application Development and Automation Discussions

secondary index

Former Member — Tue, 19 Feb 2008 16:35:55 GMT

hi all

when we go for secondary index

Re: secondary index

Former Member — Tue, 19 Feb 2008 16:40:08 GMT

We will go for for the secondary index when there are no primary key fields in the where condition of a Select query inorder to improve the performance.

Thanks

Kiran.

Re: secondary index

Former Member — Tue, 19 Feb 2008 17:09:30 GMT

Hi Rohit,

[http://help.sap.com/saphelp_nw70/helpdata/en/cf/21eb20446011d189700000e8322d00/content.htm]

I think this link will answer your question.

<REMOVED BY MODERATOR>

Thanks,

Karthik

Edited by: Alvaro Tejada Galindo on Feb 19, 2008 12:13 PM

Re: secondary index

Former Member — Tue, 19 Feb 2008 18:04:56 GMT

Hi,

You can go for secondary index, to increase the performance of the report. When your select statement does not have any of the key fields used then you can create secondary index, these fields will act as additional key fields for the table.

At the max you can have 9 secondary index's for a table. For better performance you can go upto 6.

Thanks,

Sriram Ponna.