Welcome to SQL Optimizer
About SQL Optimizer
SQL Optimization Workflow
New in This Release
Additional Resources
Database Privileges
Database Privileges Script
Connect to the Database
Windows Layout
Customize Toolbars
Keyboard Shortcuts
Support Bundle
Register SQL Optimizer
Check for Updates
SQL Operations
Optimize SQL
ALL PARTITION
ALTER INDEX
AND EQUAL
ANTI JOIN
BITMAP AND
BITMAP COMPACTION
BITMAP CONSTRUCTION
BITMAP CONVERSION
BITMAP INDEX
BITMAP JOIN INDEX UPDATE
BITMAP JOIN INDEX UPDATE STATEMENT
BITMAP KEY ITERATION
BITMAP MERGE
BITMAP MINUS
BITMAP OR
BUFFER SORT
CARTESIAN JOIN
COLLECTION ITERATOR
CONCATENATION
CONNECT BY
CONNECT BY PUMP
COUNT
COUNT STOPKEY
CREATE AS SELECT
CUBE SCAN
DDL STATEMENT
DELETE
DOMAIN INDEX
FAST FULL INDEX SCAN
FILTER
FIRST ROWS
FIXED INDEX
FIXED TABLE
FOR UPDATE
FULL INDEX SCAN
FULL INDEX SCAN DESCENDING
FULL INDEX SCAN (MIN/MAX)
HASH GROUP BY
HASH GROUP BY PIVOT
HASH JOIN
HASH JOIN BUFFERED
HASH PARTITION
HASH UNIQUE
INDEX
INDEX BUILD NON UNIQUE
INDEX RANGE SCAN
INDEX RANGE SCAN DESCENDING
INDEX RANGE SCAN (MIN/MAX)
INDEX SAMPLE FAST FULL SCAN
INDEX SKIP SCAN
INDEX SKIP SCAN DESCENDING
INDEX UNIQUE SCAN
INLIST ITERATOR
INLIST PARTITION
INSERT
INTERSECTION
INTO
INVALID PARTITION
ITERATOR PARTITION
LOAD AS SELECT
MAT_VIEW ACCESS
MAT_VIEW REWRITE ACCESS
MERGE JOIN
MINUS
MULTI-TABLE INSERT
NESTED LOOPS
OUTER JOIN
PARTITION
PARTITION HASH EMPTY
PARTITION LIST
PARTITION RANGE
PROJECTION
PX BLOCK ITERATOR
PX COORDINATOR
PX ITERATOR
PX PARTITION
PX PARTITION HASH ALL
PX PARTITION LIST ALL
PX PARTITION RANGE ALL
PX RECEIVE
PX SEND
RANGE PARTITION
RECURSIVE EXECUTION
RECURSIVE WITH PUMP
REFERENCE MODEL
REMOTE
SELECT
SEMI JOIN
SEQUENCE
SINGLE PARTITION
SINGLE RANGE PARTITION
SORT
SORT AGGREGATE
SORT GROUP BY
SORT GROUP BY CUBE
SORT GROUP BY NOSORT
SORT GROUP BY ROLLUP
SORT JOIN
SORT ORDER BY
SORT UNIQUE
SQL MODEL
TABLE ACCESS
TABLE ACCESS BY GLOBAL INDEX ROWID
TABLE ACCESS BY INDEX ROWID
TABLE ACCESS BY LOCAL INDEX ROWID
TABLE ACCESS BY ROWID
TABLE ACCESS BY USER ROWID
TABLE ACCESS CLUSTER
TABLE ACCESS FULL
TABLE ACCESS HASH
TABLE ACCESS SAMPLE
TABLE QUEUE
TEMP TABLE GENERATION
TEMP TABLE TRANSFORMATION
UNION
UNION ALL
UNION ALL (RECURSIVE WITH)
UNPIVOT
UPDATE
VIEW
VIEW PUSHED PREDICATE
WINDOW
Create Optimize SQL Sessions
Open Optimizer SQL Sessions
Rewrite SQL
Optimize Indexes
About Optimizing SQL (SQL Rewrite)
Select Connection
Optimize SQL Statements
Auto Optimize SQL Statements
Test Run SQL Alternatives
Test Run Settings
Test Run Special (Current) Settings
Select an Execution Method
Stop and Resume Optimization Process
Create User Alternatives
Set Bind Variables
Test Run Different Bind Values
Use Execution Plans
Generate Execution Plan Alternatives
About Execution Plans
Retrieve Execution Plans
Review Execution Plans
Fill Missing Execution Plans
Animate Execution Plans
Copy Execution Plans
Test for Scalability (Optimize SQL)
Alter Session Parameters
Retrieve Run Results
Review Alternatives
Filter Columns
Generate Index Alternatives
About Generating Index Alternatives
Generate Index Alternatives
Test Run Index Alternatives
Analyze Index Impact (SQL Rewrite)
View SQL Information (SQL Rewrite)
View Schema Information (SQL Rewrite)
Show or Hide Table Attributes
Show or Hide Index Attributes
Show or Hide Column Attributes
View Statistics Information (SQL Rewrite)
Compare SQL Statements
View Best Practices
Generate Optimize SQL Resolution Report
Register SQL Translation
Deploy Outlines
Send SQL Back to Original Application
Troubleshoot Optimization Results
About Optimizing SQL (Plan Control)
Select Connection
Generate Execution Plan Alternatives
Test Run Execution Plan Alternatives
Test Run Settings
Test Run Special Current Settings
Select an Execution Method
Set Bind Variables
Test Run Different Bind Values
Use Execution Plans
Retrieve Run Results
Review Plan Alternatives
Filter Columns
View SQL Information (Plan Control)
View Schema Information (Plan Control)
Show or Hide Table Attributes
Show or Hide Index Attributes
Show or Hide Column Attributes
View Statistics Information (Plan Control)
Compare Execution Plan Alternatives
Generate Optimize SQL Resolution Report
Deploy Baselines
About Optimize Indexes
Select SQL Workload Source
Optimize AWR Workload
Optimize SGA Workoad
Optimize Scan Code Workload
Review Optimize Indexes Results
Send to Analyze Impact
Create Index Scripts
Generate Report
Use Execution Plans
Batch Optimize SQL
About Batch Optimization
Use Batch Optimize
Filter Database Objects (Batch Optimize)
Set Bind Variables (Batch Optimize)
Change Schemas
Manage Batches
Manage Jobs (Batch Optimize)
View Best Alternatives
Filter Columns
Use Execution Plans
Test for Scalability (Batch Optimize)
Generate Optimized Scripts
Send to Optimize SQL (Batch Optimize)
Send to Optimize Indexes (Batch Optimize)
Send to Analyze Impact
Generate Optimized Job Reports
Generate Batch Summary Reports
Scan SQL
About Scanning SQL
About SQL Conversion
Create Scan SQL Groups
Scan SQL
Filter Database Objects (Scan SQL)
Manage Jobs (Scan SQL)
View_SQL_Classification
View SQL Text
View SQL Information (Scan SQL)
Filter Columns
Use Execution Plans
Create Benchmark Factory Import Files (Scan SQL)
Send to Optimize SQL or Batch Optimize (Scan SQL)
Send to Optimize Indexes (Scan SQL)
Send to Analyze Impact
View Inspect SGA File Statistics (Scan SQL)
Generate Scanned Job Reports
Generate Group Summary Reports
Inspect SGA
About Inspect SGA
Create Inspect SGA Groups
Use Inspect SGA
Manage Jobs (Inspect SGA)
View SQL Statistics
View SQL Text (Inspect SGA)
Filter Columns
Use Execution Plans
Flush Shared Pool
Create Benchmark Factory Import Files (Inspect SGA)
Send to Optimize SQL or Batch Optimize (Inspect SGA)
Send to Optimize Indexes (Inspect SGA)
Send to Analyze Impact
Generate Inspected SQL Report
Analyze Impact
About Analyze Impact
Analyze Impact of Additional Indexes
Analyze Impact of Parameter Change
Compare Databases
Use Custom Scripts to Analyze Impact
Collect SQL and Run Analysis
Review Results
Create Index Scripts
Generate Report
Manage Plans
About Managing Plans
Create Manage Plans Sessions
Manage Outlines
Manage Baselines
Filter Columns
Configure General Settings (Baselines Management)
Export, Import, and Migrate Baselines
Send to SQL Optimizer (Baselines Management)
Configure Options
General
SQL Optimizer Tutorials
General Options
SQL Classification
Trace Setup
Execution Plan
Test for Scalability
Directory Setup
Appearance
Optimize SQL
Optimizer
Batch Optimize
Scan SQL
Manage Plans
Intelligence (Optimize SQL)
Optimization
Hints
Index Generation
Intelligence (Plan Control)
Test Run
Best Practices
Optimization Approaches
Access Paths
Query Transformations
Join Orders / Operations
Parallel Execution
Other Hints
Quota
Tutorial: Optimize SQL (SQL Rewrite)
Tutorial: Generate Indexes
Tutorial: Deploy Outlines
Tutorial: Best Practices
Tutorial: Send Indexes to Analyze Impact
Tutorial: Optimize SQL (Plan Control)
Tutorial: Batch Optimize SQL
Tutorial: Scan SQL
Tutorial: Inspect SGA
Tutorial: Analyze Impact
Tutorial: Manage Outlines
About Us
Legal Notices
Query Transformations
Use this page of the Options dialog to specify customized optimization settings for SQL Rewrite.
To enable the options on this page if disabled, go to Optimize SQL | Optimizer | Intelligence in the Options dialog and select Custom Settings. See Intelligence (Optimize SQL) for more information.
To select query transformation hints
-
Click
in the main menu.
-
Select Optimize SQL | Optimizer | Hints | Query Transformations.
- Select the hints to use.
Join Orders / Operations
Use this page of the Options dialog to specify customized optimization settings for SQL Rewrite.
To enable the options on this page if disabled, go to Optimize SQL | Optimizer | Intelligence in the Options dialog and select Custom Settings. See Intelligence (Optimize SQL) for more information.
To select join order / operation hints
-
Click
-
Select Optimize SQL | Optimizer | Hints | Join Orders / Operations.
- Select the hints to use.
Parallel Execution
Use this page of the Options dialog to specify customized optimization settings for SQL Rewrite.
To enable the options on this page if disabled, go to Optimize SQL | Optimizer | Intelligence in the Options dialog and select Custom Settings. See Intelligence (Optimize SQL) for more information.
To select join order / operation hints
-
Click
-
Select Optimize SQL | Optimizer | Hints | Parallel Execution.
- Select the hints to use.
Other Hints
Use this page of the Options dialog to specify customized optimization settings for SQL Rewrite.
To enable the options on this page if disabled, go to Optimize SQL | Optimizer | Intelligence in the Options dialog and select Custom Settings. See Intelligence (Optimize SQL) for more information.
To select other hints
-
Click
-
Select Optimize SQL | Optimizer | Hints | Other.
- Select the hints to use.