立即与支持人员聊天
与支持团队交流

SQL Optimizer for SQL Server 10.1.2 - User Guide

Welcome to SQL Optimizer Optimize SQL
Create Optimize SQL Sessions Open Optimize SQL Sessions Rewrite SQL Plan Control Use Temporary Tables
Optimize Indexes Find SQL Scan SQL Manage Plan Guides Configure Options Tutorials About Us

Copy Execution Plans

To copy an execution plan

» Right-click the execution plan and select Copy.

Note: You can paste execution plans displayed as a Tree Plan or Plain Language Plan in text or bitmap format. Applications such as Microsoft Word allow you to choose the format using the Paste Special option. You can use text applications such as Notepad to paste execution plans in text format or graphic applications such as MS Paint to paste execution plans in bitmap format.

 

Related Topics

Fill Missing Execution Plans

 

Scan SQL

SQL Scanner helps identify problematic SQL statements in your database environment by automatically extracting statements from your source code. SQL Scanner retrieves and analyzes the execution plans for the extracted statements and classifies them according to complexity. You can then optimize statements classified as problematic using SQL Optimizer. SQL Scanner can extract and analyze statements from the following:

Database Objects Database objects with embedded SQL statements which includes stored procedures, triggers, views, rules, and defaults.
Single Command Line Dynamic (SCLD) Files and Database Objects

Database objects and files that contain SCLD SQL statements including Java or Visual Basic source code.

Notes: SCLD SQL statements are the only type of dynamic SQL statements that SQL Scanner can extract directly from source code.

Microsoft SQL Server Profiler Files Trace files and tables created using Microsoft SQL Server Profiler. You can use SQL Server Profiler to capture SQL statements while the applications are running.
Text/Binary Files Text and binary files that contain embedded SQL statements.
COBOL Files COBOL source code that contains embedded SQL statements.

Notes: If your application generates dynamic SQL statements at run time, use SQL Server Profiler to capture the statements and store the output in a trace file or trace table. Afterwards, use SQL Scanner to extract and analyze the captured statements.

 

Related Topics

Scan SQL

Manage Scan Jobs

Send to Optimize SQL

About Scanning SQL

SQL Scanner helps identify problematic SQL statements in your database environment by automatically extracting statements from your source code. SQL Scanner retrieves and analyzes the execution plans for the extracted statements and classifies them according to complexity. You can then optimize statements classified as problematic using SQL Optimizer. SQL Scanner can extract and analyze statements from the following:

Database Objects Database objects with embedded SQL statements which includes stored procedures, triggers, views, rules, and defaults.
Single Command Line Dynamic (SCLD) Files and Database Objects

Database objects and files that contain SCLD SQL statements including Java or Visual Basic source code.

Notes: SCLD SQL statements are the only type of dynamic SQL statements that SQL Scanner can extract directly from source code.

Microsoft SQL Server Profiler Files Trace files and tables created using Microsoft SQL Server Profiler. You can use SQL Server Profiler to capture SQL statements while the applications are running.
Text/Binary Files Text and binary files that contain embedded SQL statements.
COBOL Files COBOL source code that contains embedded SQL statements.

Notes: If your application generates dynamic SQL statements at run time, use SQL Server Profiler to capture the statements and store the output in a trace file or trace table. Afterwards, use SQL Scanner to extract and analyze the captured statements.

 

Related Topics

Scan SQL

Manage Scan Jobs

Send to Optimize SQL

About SQL Conversion

SQL Scanner retrieves execution plans when it extracts SQL statements. If SQL Scanner cannot retrieve the execution plan, it attempts to apply a SQL conversion to render the statement as a valid standalone statement. Click the following to display more information for each type of conversion SQL Scanner attempts to apply:

  

Related Topics  

 

 

相关文档

The document was helpful.

选择评级

I easily found the information I needed.

选择评级