Skip to Content

Hana Row and Column Store Vs Conventional Table Indexes

Hi,

I know HANA stores the records in row and column store combined so that the retrieval of the record is faster since the row part acts like an index.

However how is this different from the earlier table indexes used by the conventional databases? Eventhough Hana claims that their table design will be faster to retrieve with row and column format data structure, the same logic was also used by the index of a conventional table. Hence i see there is no difference here in terms of the table designs.

What i mean to say is, although the conventional tables store the records in row format, the retrieval process was assisted by additional indexes created together with the tables.

Hence will it be wrong to say that the conventional tables retrieval process will be slower than Hana tables considering the table indexes which are there to assist them?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Jun 13, 2017 at 09:18 AM

    Hello Sanjay,

    There is an excellent white paper by Hasso Plattner that answers your question:

    A Common Database Approach for OLTP and OLAP Using an In-Memory Column Database

    Best regards

    Frank

    Add comment
    10|10000 characters needed characters exceeded