cancel
Showing results for 
Search instead for 
Did you mean: 

Modelling only possible for column tables?

Former Member
0 Kudos

Hi,

I have read in one of the modeling documents that modeling is possible only for column tables. Is that true?

In case it is true then why are we allowed to create different other table types like row store, history column, global temporary and local temporary?

Can you please help clear my doubt.

Regards,

Sindhura.

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi Sindhura,

One of the major advantages, which i feel is that the column tables are optimized for reading rather than writing and since the HANA Models are used for reporting and analysis purpose, that is the best suited table.

Row tables are optimized for write operations.

Regards,

Piyush

former_member184768
Active Contributor
0 Kudos

Hi Sindhura,

HANA Information Models can be created only on the column tables. Other tables are used for different purposes.

You can refer to CREATE TABLE section http://help.sap.com/hana/html/sql_create_table.html.

It explains all the table types and its use.

Row store : Mostly system tables, should not be used for analysis purpose.

History tables: for time travel query or data change tracking

Temporary tables: session specific and generally used duing logic implementation like Internal tables.

Regards,

Ravi