INDX TAble

[Former Member]

Hi,

Can anyone tell me what entries the INDX table stores and when these entries are accessed??

Regards

Jiku

[Former Member]

HI,

Index tables will create whenever a new table is created, all primary key values will be stored. Whenever select statement tries to retrieve data from the database table then first index tables is accessed then actual database table is accessed.

Thanks

Sriram Ponna.

[Former Member]

hi

Index's stores all primary key fields of a table.these are used for fast accessing of data from database.there are different types of index's are availble.

check the following link.

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

[Former Member]

Hi Jiku

An index can be considered a copy of a database table that has been reduced to certain fields. This copy is always in sorted form. Sorting provides faster access to the data records of the table.

For Example using a binary search. The index also contains a pointer to the corresponding record of the actual table so that the fields not contained in the index can also be read.

The primary index is distinguished from the secondary indexes of a table. 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.

Reward me points.

By

Pari