Welcome to SQL Optimizer
About SQL Optimizer
New in This Release
Connect to SQL Server
SQL Optimization Workflow
Support Bundle
Join the SQL Optimizer Community
Licensing
Optimize SQL
Create Optimize SQL Sessions
Open Optimize SQL Sessions
Rewrite SQL
Optimize Indexes
About Optimizing SQL (SQL Rewrite)
Select Connection
Optimize SQL Statements
Test Run SQL Alternatives
Auto Optimize SQL Statements
Test Run Settings
Test Run Special Settings
SQL Selector Workflow: SQL Rewrite
Execution Plans
Plan Control
About Execution Plans
Get Execution Plans
Fill Missing Estimated Plans
Copy Execution Plans
Animate Execution Plans
Compare Plan Cost
View Missing Indexes
Optimize SQL Used in Cursors
Generate Index Alternatives
About Generating Index Alternatives
Generate Index Alternatives
Test Run Index Alternatives
Troubleshoot Optimization Results
Retrieve Run Results
Create User Defined Alternatives
Execute Statements and View Results
Create Virtual Indexes
Set Bind Variables
Test for Scalability
Review Alternatives
Alternative SQL Text
View SQL Information (SQL Rewrite)
View Execution Statistics (SQL Rewrite)
View Schema Information (SQL Rewrite)
View Cursor Settings and Bind Variables (SQL Rewrite)
Show or Hide Table Attributes
Show or Hide Index Attributes
Show or Hide Column Attributes
Compare SQL Statements
Generate Optimize SQL Resolution Report
Troubleshoot Optimization Results
About Optimizing SQL (Plan Control)
Select Connection
Generate Execution Plan Alternatives
Test Run Execution Plan Alternatives
Auto Optimize Using Plan Guide
Test Run Settings
Test Run Special Settings
SQL Selector Workflow: Plan Control
Execution Plans
Use Temporary Tables
About Execution Plans
Get Execution Plans
Fill Missing Execution Plans
Fill Missing Estimated Plans
Copy Execution Plans
Animate Execution Plans
Compare Plan Cost
View Missing Indexes
Set Bind Variables
Retrieve Run Results
Review Plans
Original SQL Text
View SQL Information (Plan Control)
View Execution Statistics (Plan Control)
View Schema Information
View Bind Variables
Show or Hide Table Attributes
Show or Hide Index Attributes
Show or Hide Column Attributes
Compare Execution Plan Alternatives
Generate Optimize SQL Resolution Report
Deploy Plan Guides
About Optimize Indexes
Select Connection
Select a SQL Workload Source
Optimize Indexes from Scanned Code Workload
Optimize Indexes for Plan Cache Workload
Optimize Indexes for SQL Profiler Trace Files or Trace Tables Workload
Optimize Indexes for Spotlight Statistics Repository Workload
View Optimize Indexes Results
Create Index Scripts
Generate an Optimize Indexes Workload Report
Use Execution Plans
Find SQL
About Finding SQL
Find SQL - Homepage
Find SQL from Plan Cache
Scan SQL
Start finding SQL from Plan Cache
Select Connection
Search Results
Top SQL - Summary Chart
Top Batches - Summary Chart
Top Database Objects - Summary Chart
SQL by Classification
SQL Details Page
Batch Details Page
Database Object Details Page
SQL Classification Categories
Find SQL from SQL Trace
Start finding SQL from SQL Trace
Select Connection for SQL Trace
Search Results
Top SQL - Summary Chart
Top Batches - Summary Chart
Top Database Objects - Summary Chart
SQL by Classification
SQL Details Page
Batch Details Page
Database Object Details Page
SQL Classification Categories
Use Execution Plans
About Scanning SQL
About SQL Conversion
Scan SQL
Filter Database Objects
Scan Source Code with Temp Tables
Use Temporary Tables
Manage Groups
Manage Scan Jobs
Create Benchmark Factory Import Files
View SQL Classification
SQL Classification Categories
View SQL Information (SQL Scanner)
Use Execution Plans
Manage Plan Guides
About Execution Plans (Scan SQL)
Copy Execution Plans
Animate Execution Plans
Compare Plan Cost (Scan SQL)
Send to Optimize SQL
Generate Group Summary Reports
Generate Scanned Jobs Reports
About Managing Plan Guides
Select Connection
Create Manage Plan Guides Session
Manage Plan Guides
Filter Columns
Export, Import, and Migrate Plan Guides
Send to SQL Optimizer
Viewing Plan Guide Details
Configure Options
General
Tutorials
General Options
SQL Classification Options
Ansi-SQL Options
Execution Plan Options
Test for Scalability Options
Directory Setup Options
Database Setting Options
Appearance
Optimize SQL
Scan SQL
Manage Plan Guides
Tutorial: Optimize SQL (SQL Rewrite)
Tutorial: Optimize SQL (Plan Control)
Tutorial: SQL Scanner
Tutorial: Index Alternatives
Tutorial: User-Defined Temp Tables
Tutorial: Find SQL from Plan Cache
Tutorial: Find SQL from SQL Trace
Tutorial: Optimize Indexes
Tutorial: Manage Plan Guides
About Us
Generate Optimize SQL Resolution Report
You can generate a resolution report in SQL Optimizer after you optimize your SQL statement and execute the alternatives. The resolution report includes the following:
-
Resolution summary
-
Original SQL statement
-
Optimization Session Information
-
Scenario List
-
Comparison Graph
-
Best Alternative Scenario
To generate an Optimize SQL resolution report
- Select the Optimize SQL tab in the main window.
-
Click
.
-
Click
in the Report window to customize the information displayed in the resolution report.
Tip: You can display execution plans in text mode, grayscale graphic mode, or full color graphic mode.