oracle hint 知多少
时间：2021-07-01 10:21:17
帮助过：34人阅读
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.
oracle hint 知多少
标签：access v$sql line weight erro invisible ignore hint exe
