Description of the illustration tgsql_vm_076.eps

The upper left box contains the words "Scan product_information." It points right to a box that contains "Get Row Count" and "Buffer Rows." The arrow is labeled "Row Count 289." The "Get Row Count" box is labeled "Statistics Collector." It points down to a box labeled "Default Plan." This box contains another box labeled "Subplans." The Suplans box contains two boxes. One box contains the description "Row Count Above Threshold." This box contains a box labeled "Hash Join." The other box contains the description "Row Count Below Threshold." It contains a box labeled "Nested Loops Join." The Subplans box has a callout that says "Dynamic Portion." The Default Plan box points left to a box labeled "Final Plan." This box contains a box labeled "Hash Join." The arrow is labeled "Disable Buffering."