topic Re: indexes in Application Development and Automation Discussions

indexes

Former Member — Mon, 17 Mar 2008 04:46:53 GMT

why r we using indexes for tables.what is the significance of indexes?

Re: indexes

Former Member — Mon, 17 Mar 2008 04:51:42 GMT

Hi,

Follow the below link..

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

AWARD POINTS IF USEFUL

Re: indexes

Former Member — Mon, 17 Mar 2008 04:55:39 GMT

Indexes are used to speed up the accesss of data from Database tables.

Generally Primary indexes are created by the SAP itself

It allows us to create secondary indexes

Re: indexes

Former Member — Mon, 17 Mar 2008 04:56:01 GMT

You should only create secondary indexes, for database

tables from which you mainly read, since indexes have to be

updated each time the database table is changed. secondary

indexes should contain columns that you use frequently in a

selection, and that are as highly selective as possible to

improve performance..

Regards,

Santosh

Re: indexes

Former Member — Mon, 17 Mar 2008 05:11:19 GMT

hi,

Generally indexes are used to increase the speed of the database tables.

Primary indexes are created by SAP itself.

You can create secondary indexes, for database

tables from which you mainly read, since indexes have to be

updated each time the database table is changed. secondary

indexes should contain columns that you use frequently in a

selection, and that are as highly selective as possible to

improve performance..

Re: indexes

Former Member — Mon, 17 Mar 2008 05:28:05 GMT

Hi Jayasankar,

Primary index: The primary index contains the key fields of the table and a pointer to the non-key fields of the table. The primary index is created automatically when the table is created in the database.

Secondary index: Additional indexes could be created considering the most frequently accessed field of the table.

An index can be used to speed up the selection of data records from a table.

An index can be considered to be a copy of a database table reduced to certain fields. The data is stored in sorted form in this copy. This sorting permits fast access to the records of the table (for example using a binary search). Not all of the fields of the table are contained in the index. The index also contains a pointer from the index entry to the corresponding table entry to permit all the field contents to be read.

Only those fields whose values significantly restrict the amount of data are meaningful in an index.

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

Thanks Arjun