Skip to Content
avatar image
Former Member

Logging Option in HANA Tables

Hi,

I am creating a column table in HANA. There is  an option for logging in the table definition.

Can some one clearly define its use? Why is it said like 'no logging' means that the table is persistent and globally available but data is temporary and global?

Thanks & Regards,

Monissha

Capture2.PNG (6.0 kB)
Capture.PNG (21.0 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Dec 23, 2014 at 11:42 AM

    Hi Monissha,

    If you create a table with NO LOGGING option then it means that the definition of the table is persistent and globally available while the data is temporary and global.


    With NO LOGGING option, you also have to provide retention period in seconds.

    After the specified retention period is over, the table is dropped if used physical memory of the host is above 80%.

    Refer to the below guide for more:

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

    Regards,

    Vivek

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Vivek,

      Can you please provide any use case for the above scenario?

      Thanks & Regards,

      Monissha