Skip to Content
0
Former Member
Feb 04, 2011 at 09:15 PM

How does compression works as an advantage when you're writing back?

29 Views

As we know BWA uses very high compression ratio and columnar based indexes. This way you can store more data in memory, search faster, transfer more data etc so this is a great advantage when BEx queries are searching, reading data from BWA.

Since HANA 1.0 will use similar approach, I was just curious how this will work as an advantage; everytime you write data back, doesn't it lock the column plus re-compress it?

I would like to read the algorithm/technique if anyone can share it.

Cheers

Tansu