topic please answer this immediately......... in Application Development and Automation Discussions

please answer this immediately.........

Former Member — Tue, 29 Apr 2008 13:08:55 GMT

hi frnds,

i am new to sdn. pls answer this question.

1. what is primary index and secondary index?

thanks in advance

Re: please answer this immediately.........

andreas_mann3 — Tue, 29 Apr 2008 13:14:37 GMT

look:

http://help.sap.com/saphelp_47x200/helpdata/en/cf/21eb20446011d189700000e8322d00/frameset.htm

greetings Andreas

Re: please answer this immediately.........

rodrigo_paisante3 — Tue, 29 Apr 2008 13:16:47 GMT

Hi,

Primary index is aumatically generated the movement we create a database table.

the secondary index is given in addition to the Primary Index already existing for the table ,so as to improve the data retrieval consistently, so as a result the perforamance is also increased and secondary index is also helpful in reducing the load on the Database, but do not create a lot of this..

Re: please answer this immediately.........

Former Member — Tue, 29 Apr 2008 13:20:17 GMT

primary key is created when u create the db table.

secondar index is when the primary key doesnt satistfy your data fetch needs, as in you select data more frequently which is not part of the primary key fields, then secondary index is created.

During runtime, the optimizer chooses the primary index , if the where condition doesnt form the part of primary key fields, then it search for the secondary index and uses the index to fetch the data fast.

regards,

madhumitha

Re: please answer this immediately.........

Former Member — Tue, 29 Apr 2008 13:21:07 GMT

primary index for an table consist of all its key field

where as ssecondary index is created by us

and if no index is created table always refer to primary index for all purpose to fetch the data

Re: please answer this immediately.........

Former Member — Fri, 02 May 2008 13:20:50 GMT

Thanq very much frnds.