设为首页 加入收藏

TOP

一个SQL Tuning例子(一)
2014-11-24 02:42:27 来源: 作者: 【 】 浏览:1
Tags:一个 SQL Tuning 例子
以前同事的问题,非常隐蔽的问题,一直没有发现,跟大家分析!
SQL> SET autotrace ON

SQL> SELECT
2 T5.CONFLICT_ID,
3 T5.LAST_UPD,
4 T5.CREATED,
5 T5.LAST_UPD_BY,
6 T5.CREATED_BY,
7 T5.MODIFICATION_NUM,
8 T5.ROW_ID,
9 T33.PROVIDER_FLG,
10 T15.NAME,
11 T33.CURR_PRI_LST_ID,
12 T17.KEY_VALUE,
13 T33.CITIZENSHIP_CD,
14 T33.DEDUP_KEY_UPD_DT,
15 T22.ROW_ID,
16 T31.STATE,
17 T31.ADDR,
18 T33.CON_CD,
19 T31.COUNTRY,
20 T31.CITY,
21 T31.ZIPCODE,
22 T33.CUST_SINCE_DT,
23 T33.PR_REGION_ID,
24 T33.NATIONALITY,
25 T28.CON_ID,
26 T33.PR_SECURITY_ID,
27 T4.NAME,
28 T33.MED_SPEC_ID,
29 T19.PR_EMP_ID,
30 T33.PREF_COMM_METH_CD,
31 T33.PR_OU_ADDR_ID,
32 T30.PR_EMP_ID,
33 T21.LOGIN,
34 T19.PR_EMP_ID,
35 T33.PR_PROD_LN_ID,
36 T33.PR_TERR_ID,
37 T9.PR_SMS_NUM_ID,
38 T33.PR_STATE_LIC_ID,
39 T33.AGENT_FLG,
40 T33.MAIDEN_NAME,
41 T33.MEMBER_FLG,
42 T33.PR_NOTE_ID,
43 T33.PR_INDUST_ID,
44 T26.LOGIN,
45 T9.PR_FAX_NUM_ID,
46 T33.SUPPRESS_MAIL_FLG,
47 T33.EMAIL_ADDR,
48 T33.BIRTH_DT,
49 T33.JOB_TITLE,
50 T33.MID_NAME,
51 T33.PR_DEPT_OU_ID,
52 T33.LAST_NAME,
53 T33.SEX_MF,
54 T33.PR_PER_ADDR_ID,
55 T33.PR_POSTN_ID,
56 T33.COMMENTS,
57 T28.PR_ADDR_ID,
58 T33.HOME_PH_NUM,
59 T33.OWNER_PER_ID,
60 T33.CELL_PH_NUM,
61 T33.WORK_PH_NUM,
62 T33.FAX_PH_NUM,
63 T33.FST_NAME,
64 T33.ASST_PH_NUM,
65 T18.ATTRIB_07,
66 T2.INTEGRATION_ID,
67 T33.PR_PER_PAY_PRFL_ID,
68 T33.INTEGRATION_ID,
69 T33.PRIV_FLG,
70 T33.PR_MKT_SEG_ID,
71 T33.PR_REP_SYS_FLG,
72 T33.PR_REP_MANL_FLG,
73 T33.PR_REP_DNRM_FLG,
74 T33.PR_OPTY_ID,
75 T33.SOC_SECURITY_NUM,
76 T33.PR_GRP_OU_ID,
77 T33.EMP_FLG,
78 T7.OWN_INST_ID,
79 T7.INTEGRATION_ID,
80 T33.PERSON_UID,
81 T5.NAME,
82 T2.NAME,
83 T2.PRTNR_FLG,
84 T33.PR_RESP_ID,
85 T33.BU_ID,
86 T28.STATUS,
87 T33.PR_ALT_PH_NUM_ID,
88 T33.PR_EMAIL_ADDR_ID,
89 T20.SHARE_HOME_PH_FLG,
90 T33.PR_SYNC_USER_ID,
91 T33.CON_CREATED_DT,
92 T33.EYE_COLOR,
93 T33.STOCK_PORTFOLIO,
94 T33.X_ACCNT_ID,
95 T18.ATTRIB_43,
96 T29.LOGIN,
97 T23.LAST_NAME,
98 T32.NAME,
99 T32.X_DEALER_CODE,
100 T33.SEX_MF,
101 T33.X_UPD_FLG,
102 T24.LOGIN,
103 T27.ROW_STATUS,
104 T16.PRIM_MARKET_CD,
105 T3.ROW_ID,
106 T10.OU_NUM,
107 T10.LOC,
108 T10.NAME,
109 T3.ROW_ID,
110 T10.PR_SRV_AGREE_ID,
111 T10.PR_BL_PER_ID,
112 T10.PR_SHIP_PER_ID,
113 T10.PR_BL_ADDR_ID,
114 T10.PR_SHIP_ADDR_ID
首页 上一页 1 2 3 4 5 6 7 下一页 尾页 1/8/8
】【打印繁体】【投稿】【收藏】 【推荐】【举报】【评论】 【关闭】 【返回顶部
分享到: 
上一篇oracle锁表解除 下一篇Oracle中SQLPLUS的常用指令收集与..

评论

帐  号: 密码: (新用户注册)
验 证 码:
表  情:
内  容: