Hashed files vs table lookups

Archive of postings to DataStageUsers@Oliver.com. This forum intended only as a reference and cannot be posted to.

Moderators: chulett, rschirm

Locked
admin
Posts: 8720
Joined: Sun Jan 12, 2003 11:26 pm

Hashed files vs table lookups

Post by admin »

Hello to all.
Pardon my ignorance, im trying to speed up a job in particular a lookup
which taking a little bit of time, and i would like to know what is best, a
lookup to an indexed table or an hashed file preloaded in memory? My guess
goes to the hashed file, am i right?
Thanks for your patient and kindness.
Best regards.
Pedro.

_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp
Locked