Thread: Hash join

Hash join

From
mspasic@openlinksw.com
Date:
Hello everyone,

I'm looking for a way to specify join order in SQL query. Actually, the
optimizer has chosen a plan with hash join of 2 tables, but I would like
to know if there is a way to force it to use hash join, but with replaced
tables on build phase and probe phase?

Thank you,
Mirko Spasic