| Oracle® Database Reference 10g Release 2 (10.2) Part Number B14237-02 |
|
|
View PDF |
| Oracle® Database Reference 10g Release 2 (10.2) Part Number B14237-02 |
|
|
View PDF |
ALL_OUTLINE_HINTS describes the set of hints stored in outlines accessible to the current user.
Related Views
DBA_OUTLINE_HINTS describes such hints for all outlines in the database. This is the only one of the three views that displays the OWNER column.
USER_OUTLINE_HINTS describes such hints for all outlines owned by the current user.
| Column | Datatype | NULL | Description |
|---|---|---|---|
NAME |
VARCHAR2(30) |
Name of the outline | |
OWNER |
VARCHAR2(30) |
Name of the user who created the outline | |
NODE |
NUMBER |
ID of the query or subquery to which the hint applies. The top-level query is labeled 1. Subqueries are assigned sequentially numbered labels, starting with 2. |
|
STAGE |
NUMBER |
Outline hints can be applied at three different stages during the compilation process. This column indicates the stage at which this hint was applied. | |
JOIN_POS |
NUMBER |
Position of the table in the join order. The value is 0 for all hints except access method hints, which identify a table to which the hint and the join position apply. |
|
HINT |
VARCHAR2(512) |
Text of the hint |
