on 12-15-2011 3:46 PM
Hi,
I've question for you guys. I've database in DB2 (50GB) which data I import using Data Services to HANA, I change table type to column type. And in HANA I still have 50GB database. Why does it happen? I know that my database in HANA will use less used memory than in another "row" database. It's correct?
Thanks for answer.
Regards,
Pawel
Can you check if the data in your tables are in Main or in Delta part of the column-based table? Delta part is not fully size-optimized, as its purpose is fast writing.
You may need to run MERGE DELTA OF "SCHEMA"."TABLE";
The second thing is that final compression ratio depends on multiple factors: sparsity of the table, cardinality of rows, data types used.
Pozdrawiam,
-Vitaliy
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
61 | |
9 | |
7 | |
6 | |
6 | |
6 | |
5 | |
5 | |
5 | |
5 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.