Welcome
About SQL Optimizer
Connections
Connect to the Database
SQL Optimization Workflow
Create Support Bundles
Join the SQL Optimizer Community
Register SQL Optimizer
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
Copyright
About Execution Plans
Review Execution Plans
Get Execution Plans
Fill Missing Execution Plans
Copy Execution Plans
Animate Execution Plans
Generate Index Alternatives
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
Delete Remaining Indexes
Delete Remaining Indexes window appears if it has been detected that some virtual/real indexes exist in the database and these might affect index searching result.
It is recommended to remove the unused indexes before starting the search. Click OK to remove the selected indexes.
