Chat now with support

Live-Hilfe anfordern
Registrierung abschließen

Anmelden

Preisinformationen anfragen

Vertrieb kontaktieren

SQL Optimizer for SQL Server 10.1.2 - User Guide

Inhaltsnavigation

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

View Schema Information

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 Plan Control from the Optimize SQL start page.
Select the Schema Information tab in the Plan Control window.

Tip: Click to retrieve all schema objects.
Click beside the Summary list and select a table for additional information.

Tips:

Select a row in the Statistics Summary pane and click for additional information.
Click to reorganize indexes.

Related Topics

About SQL Optimization

View SQL Information (Optimizer)

View Execution Statistics

View Bind Variables

This topic may not include a description for every field in the screen or dialog.

To view cursor settings and bind variables

Select the Optimize SQL tab in the main window.
Select the Cursor and Bind Variables tab in the Optimize SQL window.
Review the following for additional 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.

Related Topics

About SQL Optimization

View SQL Information (Optimizer)

View Execution Statistics (Plan Control)

View Schema Information

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.

Related Topics

View Schema Information

Show or Hide Column Attributes

Show or Hide Index Attributes

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 besides the Summary list and select a table.
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.

Related Topics

View Schema Information

Show or Hide Column Attributes

Show or Hide Table Attributes

Verwandte Dokumente

The document was helpful.

Bewertung auswählen

I easily found the information I needed.

Bewertung auswählen

© ALL RIGHTS RESERVED. Feedback Nutzungsbedingungen Datenschutz Cookie Preference Center