Main » SQL Optimizer Tutorials

Performance Diagnostics

Identify problem SQL using the SQL Scanner

Capture SQL from Monitoring Tables or QP Metrics using the SQL Inspector

Capture currently executing SQL using the SQL Collector for Monitor Server

Monitor Adaptive Server performance using the Performance Monitor

Performance Optimization

Optimize SQL using the SQL Optimizer

Generate Indexes for One SQL Statement using the Index Advisor

Optimize SQL without changing source code using the Abstract Plan Manager

Performance Management

Save SQL statements to SQL Repository

View SQL in the SQL Repository

Analyze SQL performance for Adaptive Server configuration parameter changes using the Configuration Analyzer

Analyze SQL performance for migrations using the Migration Analyzer

Analyze impact of new indexes using the Index Impact Analyzer

Analyze usage of indexes using the Index Usage Analyzer

Database Administration

Extract DDL for database objects using the Object Extractor

Create and Execute Transact-SQL code using the SQL Worksheet

Development

Format SQL statements using the SQL Formatter

Access information on database object using the Database Explorer

Find text in database objects and text files using the Code Finder

Functionality

Create temporary tables using the User Defined Temp Table module

Retrieve SQL statement saved in the SQL History