which is more expensive hash or modulus partitioning? when do you use modulus

which is more expensive hash or modulus partitioning? when do
you use modulus partitioning?

Question Posted / revanth

2 Answers
7092 Views
TIAA CREF, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

which is more expensive hash or modulus partitioning? when do you use modulus partitioning?..

Answer / ankit gosain

Hi All,

Hash partitioning is more expensive than modulus but it'll
give better performance as well.
The basic difference is, you can apply Modulus partitioning
for the number fields only while you can apply Hash
partitioning for Varchar and any type of field.

If you have more queries, you can mail me on
ankitgosain@gmail.com

Cheers,
Ankit :)

Is This Answer Correct ?

4 Yes

0 No

which is more expensive hash or modulus partitioning? when do you use modulus partitioning?..

Answer / nish

has partitioning when distinct key fields are less.

Modulus when the key field are very few and numeric.

Modulus = x%y so the field ought to be numeric

Is This Answer Correct ?

0 Yes

0 No

Post New Answer