We have 4 instances RAC on 18.104.22.168 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?