For queries that the user inputs manually or selects from a file, TSET submits a DUMP EXPLAIN or INSERT EXPLAIN query to export execution plan information. If the query includes the USING clause, TSET displays the Input using values to capture specific plan screen.
Input Using Values to Capture Specific Plan
Use this screen to specify values for the USING clause shown for each selected query.
The Using Variables fields display data in the Name field and Datatype field.
- Enter data values in the Value column for each query listed in the Using Query edit box.
-
Choose one of the following:
- Click OK to export specific execution plans that contain values for the USINGclause.
- Click Ignore to capture generic execution plans.
- Click Ignore All to capture generic plans for all other export queries containing the USING clause.