Execution Plans
Select the Execution Plans check box to export (in relational format) the Optimizer execution plans that are created for queries. A DUMP EXPLAIN script of the queries also is captured.
Execution plans are selected for export based on the type of export operation: by query, by database, or by workload.
Note: When the Execution Plans check box is selected, Explain Text, Step Report, and Summary Information are also captured and displayed in the Import window.
To export execution plans when exporting by query
1 From the Export by Query dialog box, click next to the QCD Name box.
2 Select a QCD from the QCD Name list.
3 Select the Execution Plans check box.
Execution plans can only be exported and imported when a QCD is specified for the export operation and the Execution Plans and Demographics check boxes are selected. If selected, demographics information is collected in the QCD.
To export execution plans when exporting by database
When exporting by database, there are two ways to capture execution plans.
1 Do one of the following:
2 [Optional] Specify a database:
a From the Export by Database dialog box, click next to the Specify Export Database box.
b Select a QCD database.
c Select the Query Capture Database and the Execution Plans check boxes.
3 [Optional] Select a QCD database:
a From the Export by Database dialog box, select a QCD database from the List of Objects pane.
b Right‑click the row to display a shortcut menu.
c Select Mark as QCD.
d Select the Execution Plans check box.
To export execution plans when exporting by workload
1 From the Export by Workload dialog box, click next to the QCD Database box.
2 Select a QCD database.
3 Select the Execution Plans check box.