HASH JOIN

Posted in 2000

mips — Fri, 11 Feb 2000 15:56:08 +0100 — source: Informix-list mailing list archive (1991-1998)

When and why Informix uses DYNAMIC HASH JOIN?

↪ replying to mips

Paul Harman — Fri, 11 Feb 2000 15:03:51 -0000 — source: Informix-list mailing list archive (1991-1998)

mips <mips@zg.tel.hr> wrote in message news:en88assp4cnu821fv36te6gie6uha17dem@4ax.com... > When and why Informix uses DYNAMIC HASH JOIN? When: whenever it can Why: because it's fast What I was told on one of my courses is that it does this usually when joining larger tables, although looking through all of my own traces I pretty much always have hash joins rather than nested loop joins. I think it will use hash joins in all but the most trivial of cases. Sorry, I can't give a more detailed answer. Paul