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