Chat now with support
Chat with Support

SQL Optimizer for Oracle 10.0 - User Guide

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
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
Optimize SQL
Create Optimize SQL Sessions Open Optimizer SQL Sessions Rewrite SQL Generate Execution Plan Alternatives
Optimize Indexes Batch Optimize SQL Scan SQL Inspect SGA Analyze Impact Manage Plans Configure Options SQL Optimizer Tutorials About Us Legal Notices

Product Improvement Program

You can help improve SQL Optimizer in future releases by allowing Quest to gather anonymous usage statistics.

To start or stop participation in the Product Improvement Program

  1. Select Help | Product Improvement Program.
  2. To allow Quest to gather anonymous usage statistics, select Yes, I want to participate.
  3. To cancel participation in the Product Improvement Program, select No, thank you.

 

You can review the privacy policy at https://www.quest.com/legal/privacy.aspx.

 

  

Legal Notices

Optional User Registration

How to opt out

If you registered at the time of installation and you no longer wish to receive monthly newsletters, you may “opt out” of receiving them by following the instructions included in each newsletter or communication or by updating your preferences here: https://www.quest.com/unsubscribe.

  

Third Party Components

This product contains some third party components (listed below). Copies of their licenses may be found at https://www.quest.com/legal/license-agreements.aspx. Source code for components marked with an asterisk (*) is available at https://opensource.quest.com.

Component License or Acknowledgement
DevExpress WinForms 16.1.4

jQuery JavaScript Library (Open Source - MIT License)
Copyright jQuery Foundation and other contributors
http://jquery.com/

jQueryUI JavaScript Library (Open Source - MIT License)
Copyright jQuery Foundation and other contributors
http://jqueryui.com/

Knockout JavaScript Library (Open Source - MIT License)
Copyright Knockoutjs.com
http://knockoutjs.com/
http://opensource.org/licenses/mit-license.php

Globalize JavaScript Library (Open Source - MIT License)
Copyright Software Freedom Conservancy, Inc.
http://jquery.org/license

Ace (Ajax.org Cloud9 Editor) (Open Source - BSD License)
Copyright 2010, Ajax.org B.V.
https://github.com/ajaxorg/ace/blob/master/LICENSE

JS Beautifier (Open Source - MIT License)
Copyright 2007-2013 Einar Lielmanis and contributors
https://github.com/beautify-web/js-beautify/blob/master/LICENSE

CodeMirror (Open Source - MIT License)
Copyright 2015 Marijn Haverbeke
https://codemirror.net/LICENSE

 

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating