Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

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?

share|improve this question
    
what type of database server? –  BlackICE Jan 4 '11 at 14:28
    
@David: oops, DB2. I'll update the question. –  BenV Jan 4 '11 at 14:39

1 Answer 1

up vote 4 down vote accepted

It's a hash join

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.