Monthly Archives: July 2011
指定query block名字和cardinality的hints
原文地址：http://www.itpub.net/thread-1462612-2-2.html SQL> select /*+ cardinality(@a 20000) cardinality(@b 20000) */ ((v.yvalue * 300) / (u.xvalue * 50)), u.xtime 2 from (select x.index_value xvalue, substr(x.update_time, 1, 14) xtime 3 from tb_indexs x 4 where x.id in (select /*+ QB_NAME(a)*/ min(a.id) 5 from tb_indexs a 6 where a.code = ‘HSI’ 7 and a.update_time > 20110701000000 8 and a.update_time [...]
Feed订阅