Chat now with support

Get Live Help
Complete Registration

Sign In

Request Pricing

Contact Sales

SQL Optimizer for SQL Server 10.1.2 - User Guide

Table of Contents

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

Create Optimize SQL Sessions Open Optimize SQL Sessions Rewrite SQL

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

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

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

Use Temporary Tables

About Temporary Tables Create Temporary Tables

Optimize Indexes

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

About Execution Plans (Optimize Indexes) Animate Execution Plans Copy Execution Plans

About Finding SQL Find SQL - Homepage Find SQL from Plan Cache

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 Execution Plans (Find SQL) Animate Execution Plans Copy Execution Plans

About Scanning SQL About SQL Conversion Scan SQL Filter Database Objects Scan Source Code with Temp Tables Use Temporary Tables

About Temporary Tables Create Temporary Tables Use Temporary Tables in Scan SQL

Manage Groups Manage Scan Jobs Create Benchmark Factory Import Files View SQL Classification SQL Classification Categories View SQL Information (SQL Scanner) Use Execution Plans

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

Manage Plan Guides

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 Options SQL Classification Options Ansi-SQL Options Execution Plan Options Test for Scalability Options Directory Setup Options Database Setting Options Appearance

Intelligence Options (Optimization) Optimization Options Hints Options Quota Options Result Options

Index Generation

Intelligence Options (Index Generation) Index Options Index Setting Options

Intelligence Options Parameterization Options

Test Run Extract SQL

Scan SQL Options

Manage Plan Guides

Manage Plan Guides Options

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 User Feedback Copyright

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.

Related Topics

About SQL Optimization

Optimize SQL Statements

Test Run SQL Alternatives

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating

© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center