Community
Application Development and Automation 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
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Read only

secondary index

Former Member

‎2008 Feb 19 4:35 PM

0 Likes
478

hi all

when we go for secondary index

hi all

when we go for secondary index

Reply
3 REPLIES 3
Read only

Former Member

‎2008 Feb 19 4:40 PM

0 Likes
453

Hi

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.

Read only

Former Member

‎2008 Feb 19 5:09 PM

0 Likes
453

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

Read only

Former Member

‎2008 Feb 19 6:04 PM

0 Likes
453

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.