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.