Difference between Hash and Modulus partitioning

Hash and Modulus techniques are Key based partition techniques. 

Hash and Modulus techniques are used for different purpose. 


If Key column data type is textual then we use has partition technique for the job. 

If Key column data type is numeric, we use modulus partition technique. 

If one key column numeric and another text then also we use has partition technique. 

if both the key columns are numeric data type then we use modulus partition technique.

Leave a Reply

Your email address will not be published. Required fields are marked *