随笔分类 -  sql优化

摘要：标量子查询的语句： select /*+ GATHER_PLAN_STATISTICS dwtest */ empno, (select count(*) from DEPT1 b where b.id = a.id) as d, (select sum(x) from DEPT1 b where 阅读全文