Modulus partiton
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 236
- Joined: Sun Apr 01, 2007 7:41 am
- Location: Michigan
Modulus partiton
i am doing a join on input data from vitual dataset and an oracle table. The key is a single column of integer type. Right now i am hash partitioning and sorting both the inputs. Instead of Hash can i use Modulus. Developer guide says YES. But if i use modulus, does it ensure related records stay in same dataset. and which is fastest, hash or modulus. How the modulus work. does it also create any table like hash
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Modulus is more efficient than Hash because it does less work. Do an all terms search for both terms; I've explained it elsewhere. Modulus algorithm does guarantee key adjacency on each partition.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.