Optimizer Directives
{ +AVOID_INDEX( tabellenname, indexname ) } ignore the index
{ +USE_INDEX( tabellenname, indexname ) } use this index
{ +USE_HASH( tabellenname ) } do a hash join
{ +AVOID_HASH( tabellenname ) } don't use hash join
{ +AVOID_NL( tabellenname ) } don' t use nested loop join
{ +USE_NL( tabellenname ) } use a nested loop join
{ +FULL( tabellenname ) } do a full table scan
詳見..
http://www.prstech.com/src/informix_faq/ifaq01.htm
全站熱搜
留言列表