Partitioning strategy Help
I will have several tables with 6,000,000 rows in my database. As an example, this is one of the tables:
Our queries are going to be over the field FIELD1_PK on the where clause and that number is generated using a sequence. That table will start with 5M rows, and will increase with 3M rows/month.
My question is the type of partition that I should use considering that if I have 2 partitions, all of The new values will go to the right side of the partition.
Should I use hash partition over that field? not partition at all?