Skip to Content
0

Hana Row and Column Store Vs Conventional Table Indexes

Jun 13, 2017 at 08:28 AM

43

avatar image

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?

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Frank Schuler
Jun 13, 2017 at 09:18 AM
1

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

Show 1 Share
10 |10000 characters needed characters left characters exceeded

Yeah man, it is better to listen from the creators than listening all over, LOL. Thanks for this article, worth every read.

0