Skip to Content
avatar image
Former Member

Modelling only possible for column tables?

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Jan 23, 2013 at 02:31 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 24, 2013 at 05:27 PM

    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

    Add comment
    10|10000 characters needed characters exceeded