hi
is there any performance issue..
when we use same hash file for multiple lookups for different values.
ie we have to create separate hash file or
use same hash file with multiple links
which is better please send me the answer
adv thks
Regarding HashFile
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
It depends. How many rows? How big are the rows? For small values of each, an all-in-one-hashed-file is appropriate. But if they get too big then separate hashed files (note: hashed, not hash) would be appropriate.
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.