oracle hint 知多少

oracle hint 可以用v$sql_hint 来查询,比如有多少个INDEX相关的hint

>set pagesize 500>set linesize 300>select NAME,CLASS,VERSION,PROPERTY from v$sql_hint where name like ‘%INDEX%‘;

NAME                                 CLASS                                  VERSION              PROPERTY
---------------------------------------------------------------- ---------------------------------------------------------------- ------------------------- ----------
INDEX_STATS                             TABLE_STATS                              10.1.0.3               272
DOMAIN_INDEX_SORT                         DOMAIN_INDEX_SORT                          8.1.5                  0
DOMAIN_INDEX_NO_SORT                         DOMAIN_INDEX_SORT                          8.1.5                  0
LOCAL_INDEXES                             LOCAL_INDEXES                              9.0.0                  0
USE_NL_WITH_INDEX                         USE_NL_WITH_INDEX                          10.1.0.3               304
INDEX_ASC                             ACCESS                               8.1.0                304
INDEX                                 ACCESS                               8.0.0                304
INDEX_DESC                             ACCESS                               8.1.0                304
NO_INDEX                             NO_INDEX                              8.1.5                304
INDEX_FFS                             ACCESS                               8.1.0                304
NO_INDEX_FFS                             NO_INDEX_FFS                              10.1.0.3               304
INDEX_SS                             ACCESS                               9.0.0                304
INDEX_SS_ASC                             ACCESS                               9.0.0                304
INDEX_SS_DESC                             ACCESS                               9.0.0                304
NO_INDEX_SS                             NO_INDEX_SS                              10.1.0.3               304
INDEX_COMBINE                             ACCESS                               8.1.0                432
INDEX_JOIN                             ACCESS                               8.1.5                304
INDEX_RRS                             ACCESS                               9.0.0                304
PARALLEL_INDEX                             PARALLEL_INDEX                           8.1.0                288
NO_PARALLEL_INDEX                         PARALLEL_INDEX                           8.1.0                288
DOMAIN_INDEX_FILTER                         DOMAIN_INDEX_FILTER                          11.1.0.6               304
NO_DOMAIN_INDEX_FILTER                         NO_DOMAIN_INDEX_FILTER                       11.1.0.6               304
INDEX_RS_ASC                             ACCESS                               11.1.0.6               304
INDEX_RS_DESC                             ACCESS                               11.1.0.6               304
NUM_INDEX_KEYS                             ACCESS                               10.2.0.3               304
XMLINDEX_REWRITE                         XMLINDEX_REWRITE                          11.1.0.6                 0
NO_XMLINDEX_REWRITE                         XMLINDEX_REWRITE                          11.1.0.6                 0
XMLINDEX_REWRITE_IN_SELECT                     XMLINDEX_REWRITE                          11.1.0.6                 0
NO_XMLINDEX_REWRITE_IN_SELECT                     XMLINDEX_REWRITE                          11.1.0.6                 0
USE_INVISIBLE_INDEXES                         USE_INVISIBLE_INDEXES                          11.1.0.6                 0
NO_USE_INVISIBLE_INDEXES                     USE_INVISIBLE_INDEXES                          11.1.0.6                 0
IGNORE_ROW_ON_DUPKEY_INDEX                     IGNORE_ROW_ON_DUPKEY_INDEX                      11.1.0.7               288
CHANGE_DUPKEY_ERROR_INDEX                     CHANGE_DUPKEY_ERROR_INDEX                      11.1.0.7               288
XMLINDEX_SEL_IDX_TBL                         XMLINDEX_SEL_IDX_TBL                          11.2.0.1                 0

34 rows selected.