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: 

what is the role of secondary index in performance

Former Member
0 Kudos

hi

what is the role of secondary index in performance

1 ACCEPTED SOLUTION

Former Member
0 Kudos

Hi,

Secondary Index plays a negative role as performance point of view. If you are creating any secondary index for a table then it reducess the performance.

Ashvender

7 REPLIES 7

Former Member
0 Kudos

Refer to this related thread

Former Member

0 Kudos

Hi,

You create secondary index for a database table when you access the database records using fields that are not in the Primary key.

So you create a secondary index using the fields with whihc you query your database most.

That is the fields that you use most in the WHERE clause of the SELECT statement. if these fields are not in the Primary key or say not many or in the primary key then you create a secondary index using these fields.

In the database this index gets created and when ever you use these fields in the SELECT query's WHERE clause this INDEX will be used to fetch the data faster.

Regards,

Sesh

Former Member
0 Kudos

Hi,

Secondary Index plays a negative role as performance point of view. If you are creating any secondary index for a table then it reducess the performance.

Ashvender

Former Member
0 Kudos

Hi,

Genrally, we have primary key to acees data from db table say for mseg MBLNR,

MJAHR, ZEILE is in priamry key. but always user is not accesing table with this keys, some times it may acces iwth other keys like in case of reversal document theren is one secondary index is there which contains following fields: SMBLN, SJAHR, SMBLP.

so when u are acceisng reversal document this index is considered and result will be very fast. as comapared to non key fields.

Jogdand M B

Former Member
0 Kudos

hi

<b>they increase the average reesponse time of the transaction</b>

regards

ravish

reward if useful