Skip to Content
0
Jan 11, 2023 at 02:26 PM

Table Partitioning in Hana

150 Views Last edit Jan 11, 2023 at 02:32 PM 3 rev

Good morning,

I need advice on what is the best way to partition a Hana table.

I have a fact table with more than 3 billion data that is queried mainly on two dates: DATE X or DATE Y.

If I only apply the partition on DATA X I'm afraid that if the table is queried for DATA Y the system will ble very slow.

What do you think is the best choice?

Thank you