ABAP Keyword Documentation →  ABAP - Dictionary →  Classic Objects in ABAP Dictionary →  Database Tables →  Technical Attributes of Database Tables →  Table-Specific Technical Attributes of Database Tables 

Storage Type of Database Tables

The storage type only applies if the current database is an SAP HANA database. The specified storage type is ignored by other database systems and the platform-specific storage type is used instead. The following settings can be defined for the SAP HANA database:

• Column store

This setting should be used in the following cases:

• The database table is designed for application data analyzed in SAP HANA.

• The database table contains a very large number of rows and the storage type column store provides better compression.

• The database table has a full text index.

• The database table contains table fields with HANA data types that are supported only by the storage type column store.

• Row store

This setting should only be used in SAP HANA databases if the database table is used mainly for frequent single row accesses. This is the only possible setting for global temporary tables (GTTs).

Other versions: 7.31 | 7.40 | 7.54

Note

For more information about the differences between row store and column store on the SAP HANA database, see the SAP HANA Platform documentation.