dbms_advance_rewrite
dbms_advance_rewrite来workround原始sql:select /*+ opt_param('query_rewrite_integrit','trusted') */ * from t_or where object_id is null or object_name='aa'SCOTT@oracle11g>create table t_or as select ob...
hint no_unnest, push_subq, push_pred
http://space.itpub.net/15415488/viewspace-663969 http://www.itpub.net/thread-1391316-1-1.html swap_join_inputs USE_CONCAT)u"B+~rz J22936840The USE_CONCAT hint forces combined OR c...