8222.26
                   22177
                  HSJOIN<
                  (  27)
               1.10112e+006
         /----------+-----------
     919039                     8222.26
     794153                      22177
     TBSCAN                    >^HSJOIN
     (  28)                    (  29)
     223134                     846737
       |
  2.86308e+006
       NA
 TABLE: S0NCSTR
   S0NRP50M064
       Q62


27) HSJOIN: (Hash Join)
Cumulative Total Cost:              1.10112e+006
Cumulative First Row Cost:          1.10112e+006
Estimated Bufferpool Buffers:       124471

Predicates:
----------
149) Predicate used in Join,
        Comparison Operator:                Equal (=)
        Filter Factor:                      0.0196078

        Predicate Text:
        --------------
        (Q62.MODS_ID = Q61.MODS_ID)

150) Residual Predicate,
        Comparison Operator:                Equal (=)
        Filter Factor:                      7.30732e-007

        Predicate Text:
        --------------
        (Q62.PART_NUMBER = Q61.$C5)