Partitioning on number column
I would like to partition a large (460+ million rows) table. It has a number column with both positive and negative values. This is vendor product, looking to partition this table in such a way that all negative values goes to a single partition(basically inactive data) and positive values are hashed into multiple buckets for efficiency. Looking for some suggesstion/advice on this approach.
Thanks for your time and help in reading this post.
Ravi Arumugam
0