the partition in the main table in my system structured from a date. (daily)
i am popualting into the table 300,000,000 records each day.
my questions is if to change the partition to a week instead of a day.
(i need to keep 6 month of data in this table)
i read documention regarding parttions and still wondering if it's going to improve the queries