partition question

[dnat]

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?

[ArndW]

Partitioning isn't directly related to what you asked - you just need to ensure that both parts of the join have identical partitioning.