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

全站熱搜

hedgezzz 發表在 痞客邦 留言(0) 人氣()