Chatta subito con l'assistenza

Ottieni assistenza in tempo reale
Completa la registrazione

Accedi

Richiedi prezzo

Contatta il supporto vendite

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

Optimize SQL

Create Optimize SQL Sessions

Optimize SQL consists of SQL Rewrite sessions and Plan Control sessions. You can use SQL Rewrite sessions to optimize SQL statements by generating SQL statement or index alternatives. Use Plan Control sessions to generate execution plan alternatives for SQL statements without modifying the SQL text.

To create a new session

Select the Optimize SQL tab in the main window.
Click the arrow beside and select New SQL Rewrite Session or New Plan Control Session.

Tip: Select Switch Default Session Type to Plan Control to change the default setting for new sessions. The default setting is to create a SQL Rewrite session.

Related Topics

About SQL Optimizer

Select Connection

Tutorial: SQL Optimizer (SQL Rewrite)

Open Optimize SQL Sessions

To open a session

Select the Optimize SQL tab in the main window.
Click .
Select a SQL Rewrite or Plan Control session to open..

Related Topics

Create Optimize SQL Sessions

Rewrite SQL

Use SQL Rewrite sessions to optimize SQL statements by using SQL Optimizer's Artificial Intelligence engine to rewrite SQL statement syntax. This process begins with SQL Optimizer analyzing your original SQL statement and generating a list of semantically equivalent statement alternatives. The SQL rewrite process continues until SQL Optimizer cannot generate additional alternatives. SQL Optimizer then applies a set of SQL Server hints to each alternative to generate additional alternatives.

Once SQL Optimizer completes the SQL rewrite process, you can execute the alternatives to retrieve execution plans and run time statistics. You can compare execution times and run time statistics for alternatives to identify the best statements for your database environment.

Notes:

Although different SQL statement alternatives produce the same results, SQL Server may use different paths to retrieve data for each alternative. The database structure, indexes, and data volumes affect execution statistics. Therefore, you should test the alternatives with your database environment to find the best alternative.
The Intelligence Level setting you select affects the duration of the optimization process and the number of alternatives SQL Optimizer generates.

Related Topics

Generate Index Alternatives

About Optimizing SQL (Plan Control)

Related Documents

The document was helpful.

Seleziona valutazione

I easily found the information I needed.

Seleziona valutazione

© ALL RIGHTS RESERVED. Termini di utilizzo Privacy Cookie Preference Center