INDX Table (Cluster Table): Characteristics, Usages and Advantages

INDX Table (Cluster Table):

Detail Link:

http://help.sap.com/saphelp_470/helpdata/en/fc/eb3c1f358411d1829f0000e829fbfe/content.htm

Characteristics:

1. It’s a cluster table.

     Some other example of cluster tables:

     Like – RFBLG (BSEG, BSEC, BSED, BSES ans BSET.)

     Go to the table DD02L and enter the field Tabclass as TRANSP to get all transparent      tables, CLUSTER to get all cluster tables and POOL to get the pooled tables.

2. The data stored (fields, structures, internal tables) are store in the CLUSTD in hexadecimal format (a compressed format).

3. The length of a CLUSTD record is 2886. After reaching the length, there will be another line with increasing the SRTF2 value.SRTF2 value is start from 0.

Usage and Advantages:

1. As it holds data in hexadecimal format, it compress the data. So there will be less consumption of memory.
2. INDX table can hold data of any structure; structure independent. So using this feature we can store dynamic structured records in it. 
3. It is useful when we need to keep a huge amount of data in ABAP memory, to improve the performance.

EXPORT the internal table or variable values into INDX and then  IMPORT from INDX will accelerate the performance, because it doesn’t consume ABAP session memory.

The INDX table is useful for huge amount of data to accelerate the performance.