hi,
what is difference between hash and modules partation techniques please give me guide on this
Thanks,
Srinivas
what is difference between hash and modles partation techniq
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 1
- Joined: Thu Mar 17, 2011 9:11 am
what is difference between hash and modles partation techniq
CH.N.V.SRINVIAS
Modulus is a keyed partioning method where rows are evenly distributed according to the values in one integer key column i.e. partition = MOD(key_value / @NUMPARTITIONS) This is quicker than hash which uses cyclic redundancy check
3NF: Every non-key attribute must provide a fact about the key, the whole key, and nothing but the key. So help me Codd.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: