select a.username,(select count(*) from all_objects b where b.owner=a.username) cnt from all_users a;
create table a as select * from all_users;
create table b as select * from all_objects;
select a.username,(select count(*) from b where b.owner=a.username) cnt from a;
SQL> select * from table(dbms_xplan.display_cursor(null,null,'ALLSTATS LAST'));
PLAN_TABLE_OUTPUT
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
SQL_ID 2q0bhbzak85z9, child number 0
-------------------------------------
select a.username,(select count(*) from b where b.owner=a.username) cnt
from a
Plan hash valu
标量子查询 子查询执行次数计算公式
最新推荐文章于 2023-10-21 13:53:01 发布
本文探讨了SQL中的子查询执行次数,通过一个示例展示了如何计算子查询执行次数,并解释了标量子查询与DISTINCT的关系。文章还提供了一个查询优化的例子,将子查询改写为左连接以提高效率。
摘要由CSDN通过智能技术生成