지금 지원 담당자와 채팅
지원 담당자와 채팅

SQL Optimizer for DB2 LUW 4.3.1 - User Guide

SQL Optimizer for IBM® DB2® LUW
About SQL Optimizer for IBM DB2 LUW Getting Started Options SQL Scanner SQL Optimizer SQL Formatter SQL Inspector Database Explorer SQL Repository Index Impact Analyzer Index Usage Analyzer User-Defined Temp Table Editor Functions SQL Functions SQL Information and Functions Activity Log
Tutorials About us Copyright

Sum Statistics for a Stored Procedure

Quest SQL Optimizer for IBM® DB2® LUWmaximizes SQL performance by automating the manual, time-intensive and uncertain process of ensuring that SQL statements are performing as fast as possible. SQL Optimizer analyzes, rewrites, and evaluates SQL statements within multiple database objects, files, or SQL statements captured by the DB2 Event Monitor. With SQL Optimizer, you can analyze and optimize all your problem SQL from multiple sources. SQL Optimizer also provides you a complete index optimization and plan change analysis solution, from index recommendations to simulated index impact analysis, through comparison of multiple SQL access plans.

SQL Optimizer provides you with the following main modules.

SQL Optimizer (including SQL Rewrite and Generate Indexes functions)

SQL Formatter

Database Explorer

SQL Scanner

SQL Inspector

SQL Repository

Index Impact Analyzer

Index Usage Analyzer

 

SQL Inspector Functions

Below is a list of available functions within the SQL Inspector window.

Button or Menu Function

Schedule Menu

Inspect/Abort Inspect

Inspector & Right-click Menu

Add Inspector

Inspector & Right-click Menu

Delete Inspector

Inspector Menu

Find Inspector

File Menu

Save SQL to SQL Repository

Right-click Menu

Add/Remove Bookmark

Right-click Menu

Ad-hoc Inspect

Right-click Menu

Scan

Right-click Menu

Properties

Right-click Menu

Create Benchmark Factory Import File

Right-click Menu

Save

Refresh

Right-click Menu

Create Benchmark Factory Import File

 

Related Topics

SQL Inspector Overview

SQL Inspector Window

Database Explorer

Quest SQL Optimizer for IBM® DB2® LUWmaximizes SQL performance by automating the manual, time-intensive and uncertain process of ensuring that SQL statements are performing as fast as possible. SQL Optimizer analyzes, rewrites, and evaluates SQL statements within multiple database objects, files, or SQL statements captured by the DB2 Event Monitor. With SQL Optimizer, you can analyze and optimize all your problem SQL from multiple sources. SQL Optimizer also provides you a complete index optimization and plan change analysis solution, from index recommendations to simulated index impact analysis, through comparison of multiple SQL access plans.

SQL Optimizer provides you with the following main modules.

SQL Optimizer (including SQL Rewrite and Generate Indexes functions)

SQL Formatter

Database Explorer

SQL Scanner

SQL Inspector

SQL Repository

Index Impact Analyzer

Index Usage Analyzer

 

About Database Explorer

The Database Explorer accesses information on database objects from the database server and provides details on tables, views, aliases, nicknames, procedures, functions, triggers, packages and user-defined types. The type of information given is dependent on the object type and your privileges to access specific database objects.

 

Related Topics

관련 문서

The document was helpful.

평가 결과 선택

I easily found the information I needed.

평가 결과 선택