warren@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 skip the build phase of
> the hash join?
Maybe maintaining a materialized view then using it in the queries would
be sufficient to solve your problem?
--
dim