Description of the illustration tgsql_vm_061.eps

This graphic shows a SQL Tuning Advisor icon. A box containing the text "SELECT . . . UNION" points to the advisor. The advisor points to an Optimizer box that contains an Automatic Tuning Optimizer (ATO) box. A calculator icon is attached to the Optimizer box. The ATO box points down to a box containing a box that contains the text: "SQL Constructors (NOT IN, UNION)," "Data Type Mismatches," "Design Mistakes (No WHERE Clause)." This box points down to a box containing the text "SELECT . . . UNION ALL." The arrow is labeled "Restructured."