Send to Optimize SQL or Batch Optimize (Scan SQL)
This topic focuses on information that may be unfamiliar to you. It does not include all step and field descriptions.
To send a SQL statement to Optimize SQL or Batch Optimize SQL
-
Select the Scan SQL tab in the main window.
- Click beside the Group list and select a group.
- Select a job in the Job List pane.
-
Select a SQL statement in the SQL List pane.
-
Click the arrow beside and select an option to optimize the statement using a SQL Rewrite or Plan Control session in Optimize SQL or in Batch Optimize SQL.
Tip: SSee Use Batch Optimize for more information.
Related Topic
About Scanning SQL
Scan SQL
View SQL Text (Scan SQL)
About Optimizing SQL (SQL Rewrite)
About Optimizing SQL (Plan Control)
Send to Optimize Indexes (Scan SQL)
You can send scan jobs to Optimize Indexes to generate an index set that improves the performance of the SQL statements in the job. See About Optimize Indexes for more information.
Note: This topic focuses on information that may be unfamiliar to you. It does not include all step and field descriptions.
To send a scan job to Optimize Indexes
-
Select the Scan SQL tab in the main window.
- Click beside the Group list and select a group.
- Select a job in the Job List pane.
- Click . A Scan Code workload session opens in Optimize Indexes.
- The Choose SQL to Include in Workload dialog opens and displays the SQL that you sent from Scan SQL. Use this dialog to delete or modify SQL statements.
- See Optimize Indexes from Scanned Code Workload for more information about searching for new indexes from a scanned code workload.
Related Topics
Optimize Indexes from Scanned Code Workload
About Scanning SQL
Scan SQL
Send to Analyze Impact
You can send jobs to Analyze Impact to evaluate the impact that a change can have on the SQL workload.
To send a job to Analyze Impact
- Select the Scan SQL tab in the main window.
- Select a group from the Group drop-down list.
- Select a job in the Job List and click .
- When prompted, select the type of impact analysis you want to perform.
- The Analyze Impact module opens to the Details page for the type of analysis you selected. Specify the details for the type of analysis (or change) you selected. See About Analyze Impact for more information.
- After specifying analysis/change details, click . The SQL page for the Scan Code collection method opens and displays the SQL that you sent from Scan SQL. See Collect SQL and Run an Impact Analysis for more information.
Related Topics
About Analyze Impact
Collect SQL and Run an Impact Analysis
View Inspect SGA File Statistics (Scan SQL)
This topic focuses on information that may be unfamiliar to you. It does not include all step and field descriptions.
To view statistics for an Inspect SGA file from Scan SQL
- Select the Scan SQL tab in the main window.
- Click beside the Group list and select a group.
-
Right-click a job in the Job List pane and select Open in Inspect SGA.
Note: This option is only available if you select a job created from an Inspect SGA file.
Tip: To view statistics for an individual statement, select the statement in the SQL List pane, right-click the SQL Text pane and select Open in Inspect SGA.
Related Topics
About Scanning SQL
Scan SQL
About Inspect SGA