5.222 DBA_OUTLINE_HINTS
DBA_OUTLINE_HINTS
describes the set of hints stored in all outlines in the database.
Related View
USER_OUTLINE_HINTS
describes the set of hints stored in the outlines owned by the current user. This view does not display the OWNER
column.
Column | Datatype | NULL | Description |
---|---|---|---|
|
|
|
Name of the outline |
|
|
|
Name of the user who created the outline |
|
|
|
ID of the query or subquery to which the hint applies. The top-level query is labeled |
|
|
|
Outline hints can be applied at three different stages during the compilation process. This column indicates the stage at which this hint was applied. |
|
|
|
Position of the table in the join order. The value is |
|
|
|
Text of the hint |
See Also: