We can partition a table in multiple ways such as List, Range and Hash (Please specify more if there are any more).
If we do table a partition it would improve performance of query while fetching data.
I would like to know, is there any difference in performance if we define a specific type of parition? I mean, which one is better for performance among List, Range and Hash.
Thank you, Regards,
BI DWH BALA