Welcome
About SQL Optimizer
About Product Improvement Program
Connections
Connect to the Database
SQL Optimization Workflow
Create Support Bundles
Join the SQL Optimizer Community
Product Licensing
Additional Resources
SQL Operations
Optimize SQL
BTBSCAN
CORSUB
DELCUR
DELETE
DFETCH
DIXSCAN
EXCEPT
EXCEPTA
FETCH
FFETCH
FIXSCAN
HBJOIN
HSSCAN
INLIST
INSERT
INTERSECT
INTERSECTA
IXAND
IXOR
IXSCAN
MERGE
MERGESTMT
MIXSCAN
MSJOIN
NLJOIN
PARTITION
PIXSCAN
PRUNED
QB
RETURN
REPARTITION
RGLIST
RIDFETCH
SELUPD
SEMIJOIN
SIXSCAN
SORT
SORTRID
STARJOIN
TBSCAN
TRUNCATE
UNION
UNIONA
UPDATE
UPDCUR
WFSCAN
WORKFILE
XIXAND
XIXOR
XIXSCAN
About Optimizing SQL
Create Optimize SQL Sessions
Open Optimizer SQL Sessions
Optimize SQL Statements
Specify Session Test Run Criteria
Automatically Optimize SQL Statements
Execution Plan
Options
Tutorial
About us
Third-party contributions
Copyright
About Execution Plans
Review Execution Plans
Get Execution Plans
Fill Missing Execution Plans
Copy Execution Plans
Generate Execution Plan Alternatives
Compare Execution Plan Alternatives
Execute Execution Plan Alternatives
Retrieve Run Results
Deploy Plan Guides
Animate Execution Plans
Generate Index Alternatives
About Generating Index Alternatives
Test Run Index Alternatives
Generate Index Alternatives
Delete Remaining Indexes
Test Run SQL Alternatives
Retrieve Run Results
Create User Defined Alternatives
Set Bind Variables
Review Alternatives
Alternative SQL Text
View Optimization Details
View Schema Information
View Bind Variables
Show or Hide Table Attributes
Show or Hide Column Attributes
Compare SQL Statements
Generate Optimize SQL Resolution Report
Troubleshoot Optimization Results
View SQL Information (Plan Control)
This topic focuses on information that may be unfamiliar to you. It does not include all step and field descriptions.To view SQL information
- Select the SQL Details tab in the main window.
-
Select a Plan Control session.
-
Select the SQL Information tab in the Optimize SQL window. Click the following to view the information that displays for each pane.
SQL Information Description Classification
Statement type as classified by SQL Optimizer. Types include Simple, Complex, or Problematic. Classification Rules Detail Description Details
Applicable SQL Classification Rules. Rules used for the classification process are set on the SQL Classification Options page. Note: SQL Classification information only displays for the original SQL statement.
Plan Generation Details Description
Semantically equivalent SQL statements Number of semantically equivalent SQL statements generated by SQL Optimizer. Alternative execution plans produced Number of alternative execution plans produced for the original SQL statement. SQL statements eliminated due to identical execution plans Number of statement alternatives eliminated because they had the same execution plan as the original SQL statement.
Note: SQL statements with the same execution plan have the same run time because the database executes these statements in the same way. SQL Optimizer eliminates these alternatives.
Plan Generation Time Details Description Plan generation started at Time plan generation started. Plan generation finished at Time plan generation finished. Total plan generation time Total time to complete plan generation. Average plan generation time Average time to generate each plan alternative. Notes:
- This information is only available after you generate plan alternatives.
- Plan generation details only display for the original SQL statement.
Classification
View Schema Information
View Execution Statistics