Query user_outline_hints table : user_outline_hints « System Tables Views « Oracle PL / SQL

1. Oracle PL / SQL
2. System Tables Views
3. user_outline_hints

Query user_outline_hints table

 
SQL>
SQL> select name, hint
  2  from user_outline_hints
  3  where rownum < 50
  4  /

NAME
------------------------------
HINT
--------------------------------------------------------------------------------
MYOUTLINE
FULL(@"SEL$1" "EMP"@"SEL$1")

MYOUTLINE
OUTLINE_LEAF(@"SEL$1")

MYOUTLINE
ALL_ROWS


NAME
------------------------------
HINT
--------------------------------------------------------------------------------
MYOUTLINE
OPTIMIZER_FEATURES_ENABLE('10.2.0.1')

MYOUTLINE
IGNORE_OPTIM_EMBEDDED_HINTS


SQL>
SQL>

 

Related examples in the same category