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
View Schema Information (SQL Rewrite)
This topic may not include a description for every field in the screen or dialog.To view schema information
- Select the Optimize SQL tab in the main window.
- Select a SQL Rewrite session.
-
Select the Schema Information tab in the Optimize SQL window.
Tip: Click
to retrieve all schema objects.
-
Click
beside the Summary list and select a table for additional information.
Tips:
-
Click
to reorganize indexes..
-
Click
to analyze the selected table.
-
View Execution Statistics (SQL Rewrite)
View Cursor Settings and Bind Variables (SQL Rewrite)
To view cursor settings and bind variables
- Select the Optimize SQL tab in the main window.
-
Select the Cursor Settings and Bind Variables tab in the Optimize SQL window.
-
Review the following for additional information:
- The Cursor Type and associated Cursor Argument configured in the cursor settings window are displayed in the top pane. See Optimize SQL Used in Cursors for more information.
- The parameters for the bind variable defined for your SQL statement are displayed in the bottom pane. See Set Bind Variables for more information.
Note: Information is only displayed in this tab if you used cursor settings or variables for optimization.
View SQL Information (SQL Rewrite)
View Schema Information (SQL Rewrite)
Show or Hide Table Attributes
This topic may not include a description for every field in the screen or dialog.To show or hide a table attribute
- Select the Optimize SQL tab in the main window.
-
Select the Schema Information tab in the Optimize SQL window.
-
Right-click the header row in the Summary Details pane and select Column Chooser.
-
Add or remove table attributes by dragging the column names to and from the Customization dialog.
Show or Hide Index Attributes
This topic may not include a description for every field in the screen or dialog.To show or hide an index attribute
- Select the Optimize SQL tab in the main window.
-
Select the Schema Information tab in the Optimize SQL window.
-
Click
-
Right-click the header row of the Index Attributes pane and select Column Chooser.
Note: The Index Attributes pane is the first pane in the Schema Information tab.
-
Add or remove index attributes by dragging the column names to and from the Customization dialog.