We have 4 instances RAC on 220.127.116.11 and ASM.
We have multiple tables having billions of records and need to decide in how many partition a table should be partitioned to get the optimum performance.
In the given situation I have below 2 questions.
1. Which column/s (type) are best candidate for partition?
2. Which type of partition is best?
Is there any already proved method with statistics to decide the same?