Dimitri Fontaine skrev 2010-01-12 12.01:
war...@warrenandrachel.com writes:
When joining two large tables [common in warehousing], a hash join is
commonly selected. Calculating hash values for the merge phase is CPU
intensive. Is there any way to pre-calculate value hashes to save that
time?
war...@warrenandrachel.com writes:
> When joining two large tables [common in warehousing], a hash join is
> commonly selected. Calculating hash values for the merge phase is CPU
> intensive. Is there any way to pre-calculate value hashes to save that
> time? Would it even grant any performance to
When joining two large tables [common in warehousing], a hash join is commonly
selected. Calculating hash values for the merge phase is CPU intensive. Is
there any way to pre-calculate value hashes to save that time? Would it even
grant any performance to skip the build phase of the hash join?
