HANA Tables - Store types where is this information stored ?

[former_member204796]

Hi Folks,

We are aware that HANA tables can be of two types , Column Store or Row store , Most of the master tables and Transaction tables are Column store that promises faster Read and Row store tables are more suitable for tables with more inserts , updates etc... I can find the type of the table in "Technical Settings", "DB-Specific properties" for the table in Se11, and also in Table definition for a table in HANA studio. Just want to know where is this "Store Type" actually stored ? F1 help on the "Column store" or "Row store" does not show anything. Basically, want to check details of "Row store" tables.

Can someone help here ?

Thanks in advance.

Regards,

Suma

[Former Member]

If you are in SAP 7.3 then you goto se11, provide table name -> display. goto Utilities->Database Object-> Database utility-> Storage Parameters. there first row is IS_COLUMN_TABLE .

if IS_COLUMN_TABLE = True then it is Column store and if it is false then it is Row store.

ex: DD02L is a row store table.

Award points if issue is solved.

[former_member184768]

Hi Suma,

Please check TABLES which contains a column called TABLE_TYPE, which will tell you if the table is ROW type or COLUMN type.

Regards,

Ravi

[Former Member]

Hi Suma,

If you want to check Row store information, please check table M_RS_TABLES, it contains all row store tables.

Besides, if you want to check column store information, please check M_CS_TABLES, it contains all column store tables. For example:

Select * from "SYS"."M_RS_TABLES"/"SYS"."M_CS_TABLES".

You can reference below link to check it.

http://help.sap.com/hana/SAP_HANA_SQL_Reference_en.pdf

Hope this can help you.

Regards,

Jerry

[Former Member]

Hi Suma,

default system will create Column store data base.

The Store types are three:

• Row based
• Column based
• Table type

Please refer below guide in 12th page.

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/70e2ff67-587c-2f10-5da1-8e5ddbade...

http://scn.sap.com/community/developer-center/hana/blog/2012/07/28/create-a-table-on-sap-hana-data-b...

More info:

http://scn.sap.com/docs/DOC-25996

http://help.sap.com/hana/html/sql_create_table.html

Details about Tables (Column and Row Store) in HANA

http://www.sdn.sap.com/irj/scn/index?rid=/library/uuid/d0086776-fa54-2c10-2ea6-f8000c954e25

Regards,

V Srinivasan

[AtulKumarJain]

Hello Suma ,

If you navigate the table in hana studio, you will get information about storage type for particular table

go to studio--system--catalog--schema--tables---tablename

double click on table name you will get info .

BR
Atul