MicrosoftThanks, that is a very interesting test and I'd like to get clarification on one aspect: Table data in memory after reboot yes or no?
The behavior of Hana by default is to not(!) load the column store table-partitions into memory as part of the boot, unless needed. It is needed if the table-partition is marked as cached/preloaded, if it contains data required for the log replay and similar things.
What has been the settings in your test case in that regards?
I would have expected the boot to finish in just a few minutes instead of 2 hours also. And of course, the first query reading all columns of all partitions, that will take a long time so that at the end, it does take 2 hours until Hana really is usable. Meaning Hana is up and running plus all data is in-memory.
But I get the impression I am wrong in that assumption, hence would like to validate.
Thanks in advance for your time!
