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?
partition question
Moderators: chulett, rschirm, roy
Partitioning isn't directly related to what you asked - you just need to ensure that both parts of the join have identical partitioning.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>