2008 Mar 24 12:48 PM
Hi,
Can anyone tell me what entries the INDX table stores and when these entries are accessed??
Regards
Jiku
2008 Mar 24 12:51 PM
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.
2008 Mar 24 12:56 PM
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
2008 Mar 24 12:58 PM
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