difference between primary eindex and secondary index?

[Former Member]

hi experts

pls answer me

difference between primary eindex and secondary index?

rewads apply.

thanks.

naresh.

[Former Member]

hi experts

pls answer me

difference between primary eindex and secondary index?

rewads apply.

thanks.

naresh.

[Former Member]

Hi,

The difference between primary and secondary index is..

The primary index is generated when you activate the table.

The primary index is generated based on the primary key combination.

The secondary index is generated when you try to create secondary index on table.

If you create secondary index then you should explicitly use that in your select query when you want to use it.

Index is nothing but the table arranged the data in some specific order, when ever you use select query where class it fetches data based on this key.

Rgds,

Bujji

Edited by: Bujji on Jun 27, 2008 9:26 AM

[GauthamV]

hi,

check this link.

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

A difference is made between Primary & Secondary indexes to a table. the primary index consists of the key fields of the table and a pointer to the non-keys-fields of the table. The Primary index is generated automatically when a table is created and is created in the datebase as the same times as the table. It is also possible to define further indexes to a table in the ABAP/4 dictionary, which are then referred to as Secondary indexes.

Always it is not mandatory that an index should have all the key fields of a table. To see the index of a table

goto SE11->specify table name->click on the indexes... button on the application toolbar.

Based on your requirement you can you any of those index fields in the where clause of your query. Always its a better practice to use the index fields in the order specified. While selecting the records from a table it is always better to select the fields in the same order as specified in the table.

[former_member195383]

Hi ..

Go thru below links.....

It will solve ur query.....

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

http://www.saptechnical.com/Tutorials/ABAP/SecondaryIndex/Create.htm

\[removed by moderator\]

Edited by: Jan Stallkamp on Jun 27, 2008 10:26 AM

[Former Member]

HI,

PLEASE CHECK THE FOLLOWING LINK...FOR INFORMATION ON INDEXES..

https://www.sdn.sap.com/irj/sdn/advancedsearch?query=differencebetweenprimaryindexandsecondaryindex&cat=sdn_all

THANX AND REGARDS

KANIKA

[Former Member]

\[removed by moderator as it was just a copy and paste answer of someone else's work without giving a source\]

Edited by: Jan Stallkamp on Jun 27, 2008 10:25 AM

[Former Member]

hiiii

refer to following link.you will get good answer from there

http://www.querycat.com/faq/e429d1554a43a58ae34642b87a31ff09

regards

twinkal

[Former Member]

Hi Naresh,

Primary Index is genererated by the primary key. This is done when you activate the table.

and the Secondary Index is used to fast access the data withoout using the key value.

\[removed by moderator\]

Edited by: Jan Stallkamp on Jun 27, 2008 10:26 AM

[JanStallkamp]

Hi Naresh.

I would suggest using SDN's search function. Despite that most internet search engines are able to search to help.sap.com so using them will also give a lot of valuable input. Then there is online documentation available from every SAP system. Please search before posting!

Best regards,

Jan Stallkamp