EXPLAIN PLAN FOR
来源:互联网 发布:以下属于淘宝禁售商品 编辑:程序博客网 时间:2024/05/21 07:47
下面是10g之前初始化PLAN_TABLE需要创建的步骤:
SQL> @?/rdbms/admin/utlxplan.sql
SQL> create public synonym plan_table for plan_table;
SQL> grant all on plan_table to public;
EXPLAIN PLAN FOR
with YJFX as (SELECT a.pi_code,a.month_id,a.pi_name,a.pi_sort_num,sum(pi_val) as pi_val
FROM L2_Cw_Yjfx_Final a,
(SELECT ACCOUNT_NUMBER
FROM DM_ZMMC_ACCOUNT
WHERE (ACCOUNT_NUMBER = 'C01' OR ORG_ID_P = 'C01' OR ORG_ID_PP = 'C01' OR
ORG_ID_PPP = 'C01')
AND THE_YEAR = SUBSTR('20130808', 1, 4)
AND THE_MONTH = SUBSTR('20130808', 5, 2)
AND (ACCOUNT_NUMBER IN
(SELECT DISTINCT RES.RES_VALUE
FROM PORTAL.BI_SYS_RESOURCE RES,
PORTAL.BI_SYS_USER_RES UR,
PORTAL.BI_SYS_USERINFO U,
PORTAL.BI_SYS_RES_PERMIS RP
WHERE RES.RES_SHOWTYPE = 'ORG'
AND RES.RES_VALUE IS NOT NULL
AND RES.RES_ROOTID = '34140001033'
AND RES.RES_ID = UR.RES_ID
AND UR.USER_PKID = U.USER_PKID
AND RES.RES_ID = RP.RES_PERMID
AND RP.RES_MENUID = 4140002521
AND U.LOGIN_NAME = '10000000'
UNION ALL
SELECT 'D406' FROM dual
UNION ALL
SELECT 'B205' FROM dual
UNION ALL
SELECT 'D412' FROM dual
UNION ALL
SELECT 'C1008' FROM dual
UNION ALL
SELECT 'C100801' FROM dual
UNION ALL
SELECT 'B206' FROM dual
UNION ALL
SELECT 'D404' FROM dual
UNION ALL
SELECT 'D403' FROM dual
UNION ALL
SELECT 'D410' FROM dual
UNION ALL
SELECT 'B2011' FROM dual
))) b
where a.account_no=b.account_number
group by a.pi_code,a.month_id,a.pi_name,a.pi_sort_num
order by a.pi_sort_num)
SELECT * from yjfx;
select * from table(DBMS_XPLAN.display);
- EXPLAIN PLAN FOR
- Explain plan for last executed statement
- Oracle 执行计划 Explain plan for
- oracle explain plan for的用法
- Explain plan
- Explain Plan
- explain plan
- Explain Plan
- explain plan
- autotrace 和explain plan for可能导致执行计划错误
- Explain tables does not exist. Check the explain plan properties for this database connection.
- Explain Plan 使用
- explain plan初接触
- Oracle Explain Plan总结
- Explain Plan&& dbms_xplan
- Oracle Explain Plan
- Oracle Explain Plan
- Oracle Explain Plan
- C++空类中的默认函数
- 矩阵运算
- java 读写Excel
- 根据地址取经纬度
- UBuntu13.04安装记
- EXPLAIN PLAN FOR
- 中文编码
- IP地址划分【分类:A类 B类 C类 D类 E类】
- C++ 报错 R6030 CRT not initialized
- 利用ST提供的USB例程实现USB IAP功能
- 种类并查集
- 访问者模式
- 对话框(模态型,非模态型,偷懒型)
- Redesign Your App for iOS 7 之 页面布局