|Oracle8i SQL Reference
Release 3 (8.1.7)
Part Number A85397-01
CREATE CLUSTER to CREATE SEQUENCE, 17 of 25
OUTLINE statement to create a stored outline, which is a set of attributes used by the optimizer to generate an execution plan. You can then instruct the optimizer to use a set of outlines to influence the generation of execution plans whenever a particular SQL statement is issued, regardless of changes in factors that can affect optimization. You can also modify an outline so that it takes into account changes in these factors.
You enable or disable the use of stored outlines dynamically for an individual session or for the system.
To create an outline, you must have the
OUTLINE system privilege.
REPLACE to replace an existing outline with a new outline of the same name.
Specify the unique name to be assigned to the stored outline. If you do not specify
outline, the system generates an outline name.
Specify an optional name used to group stored outlines. For example, you could specify a category of outlines for end-of-week use and another for end-of-quarter use. If you do not specify
category, the outline is stored in the
Specify the SQL statement for which Oracle will create an outline when the statement is compiled. You can specify any one of the following statements:
The following statement creates a stored outline by compiling the
ON statement. The outline is called
salaries and is stored in the category
When this same
SELECT statement is subsequently compiled, if the
USE_STORED_OUTLINES parameter is set to
special, Oracle generates the same execution plan as was generated when the outline
salaries was created.