Db2 – What does HSJOIN mean in an Explain Plan

db2explain

I have the following EXPLAIN PLAN results from a query on my DB2 database.

0 SELECT STATEMENT ( Estimated Costs =  5.928E+02 [timerons] )
       1 RETURN
           2 HSJOIN
               3 [O] FETCH LTBP
                   4 IXSCAN LTBP~M #key columns:  0
               5 [I] FETCH LTBK
                   6 IXSCAN LTBK~V #key columns:  0

What does the HSJOIN on line 2 mean?

Best Answer

It's a hash join

Related Question