Home Oracle Commands

CREATE OUTLINE

Create a stored outline - a set of attributes used by the optimizer to generate an execution plan.

Syntax:

   CREATE [OR REPLACE] [PUBLIC|PRIVATE] OUTLINE [schema.]operator
      [FROM [PUBLIC|PRIVATE] source_outline]
         [FOR CATEGORY category] 
             ON statement;

"If you think education is expensive, try ignorance" - Derek Bok, president of Harvard

Related Commands:

OUTLINE - ALTER OUTLINE
OUTLINE - DROP OUTLINE
SESSION - ALTER SESSION
SYSTEM - ALTER SYSTEM
DBMS_OUTLN

Related Views:

DBA_OUTLINES             USER_OUTLINES
DBA_OUTLINE_HINTS        USER_OUTLINE_HINTS
SESSION_PRIVS



Back to the Top

Simon Sheppard
SS64.com