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?