select para_id
from dwf.f_Savc_Buscode b
where b.Para_Id = (SELECT MIN(Para_Id)
FROM Dwf.f_Savc_Buscode
WHERE Bus_Code = b.Bus_Code);
SQL> set linesize 200
SQL> set pagesize 200
SQL> explain plan for select para_id
from dwf.f_Savc_Buscode b
where b.Para_Id = (SELECT MIN(Para_Id)
FROM Dwf.f_Savc_Buscode
WHERE Bus_Code = b.Bus_Code); 2 3 4 5
Explained.
SQL> select * from table(dbms_xplan.display());
PLAN_TABLE_OUTPUT
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Plan hash value: 1952012934
----------------------------------------------------------------------------------------
| Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time |
-------------------
with as +分析函数优化自链接
最新推荐文章于 2022-09-12 23:44:34 发布