Tagged Questions
1
vote
1answer
695 views
What does TBSCAN GENROW mean in Explain Plan?
In a DB2 Explain Plan, what does TBSCAN GENROW (line 5 below) mean?
SELECT STATEMENT ( Estimated Costs = 1.811E+03 [timerons] )
1 RETURN
2 NLJOIN
3 [O] TBSCAN
4 SORT
...
1
vote
1answer
331 views
What does HSJOIN mean in an Explain Plan?
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] ...
