partition question
Posted: Wed Aug 05, 2009 3:18 am
Hi,
I have a file with around 20 mil data which i have to join with a table with around 200 mil data. All the records in the file are having unique keys. The key is a varchar character. In this situation , i think hash partitioning is the only best available partitioning isnt it?. Or can we use anything else?
I have a file with around 20 mil data which i have to join with a table with around 200 mil data. All the records in the file are having unique keys. The key is a varchar character. In this situation , i think hash partitioning is the only best available partitioning isnt it?. Or can we use anything else?