设为首页 加入收藏

TOP

一个SQL Tuning例子(六)
2014-11-24 02:42:27 来源: 作者: 【 】 浏览:4
Tags:一个 SQL Tuning 例子
ACT_F68_X | 2 | | 1 (0)| 00:00:01 |
| 37 | TABLE ACCESS BY INDEX ROWID | S_PRI_LST | 1 | 134 | 1 (0)| 00:00:01 |
|* 38 | INDEX UNIQUE SCAN | S_PRI_LST_P1 | 1 | | 1 (0)| 00:00:01 |
| 39 | TABLE ACCESS BY INDEX ROWID | S_MED_SPEC | 1 | 134 | 1 (0)| 00:00:01 |
|* 40 | INDEX UNIQUE SCAN | S_MED_SPEC_P1 | 1 | | 1 (0)| 00:00:01 |
|* 41 | TABLE ACCESS BY INDEX ROWID | S_CONTACT_BU | 1 | 39 | 1 (0)| 00:00:01 |
|* 42 | INDEX RANGE SCAN | S_CONTACT_BU_U1 | 1 | | 1 (0)| 00:00:01 |
| 43 | TABLE ACCESS BY INDEX ROWID | S_POSTN | 1 | 22 | 1 (0)| 00:00:01 |
|* 44 | INDEX UNIQUE SCAN | S_POSTN_U2 | 1 | | 1 (0)| 00:00:01 |
| 45 | TABLE ACCESS BY INDEX ROWID | S_ORG_EXT_FNX | 1 | 71 | 1 (0)| 00:00:01 |
|* 46 | INDEX RANGE SCAN | S_ORG_EXT_FNX_U1 | 1 | | 1 (0)| 00:00:01 |
| 47 | TABLE ACCESS BY INDEX ROWID | S_ORG_EXT | 1 | 65 | 1 (0)| 00:00:01 |
|* 48 | INDEX UNIQUE SCAN | S_ORG_EXT_U3 | 1 | | 1 (0)| 00:00:01 |
| 49 | TABLE ACCESS BY INDEX ROWID | S_ORG_EXT | 1 | 50 | 1 (0)| 00:00:01 |
|* 50 | INDEX UNIQUE SCAN | S_ORG_EXT_U3 | 1 | | 1 (0)| 00:00:01 |
| 51 | TABLE ACCESS BY INDEX ROWID | S_POSTN | 1 | 22 | 1 (0)| 00:00:01 |
|* 52 | INDEX UNIQUE SCAN | S_POSTN_U2 | 1 | | 1 (0)| 00:00:01 |
| 53 | TABLE ACCESS BY INDEX ROWID | S_ORG_EXT | 1 | 25 | 1 (0)| 00:00:01 |
|* 54 | INDEX UNIQUE SCAN | S_ORG_EXT_U3 | 1 | | 1 (0)| 00:00:01 |
|* 55 | TABLE ACCESS BY INDEX ROWID | S_CON_ADDR | 1 | 29 | 1 (0)| 00:00:01 |
|* 56 | INDEX RANGE SCAN | S_CON_ADDR_F1 | 2 | | 1 (0)| 00:00:01 |
| 57 | TABLE ACCESS BY INDEX ROWID | S_ADDR_PER | 1 | 80 | 1 (0)| 00:00:01 |
|* 58 | INDEX UNIQUE SCAN | S_ADDR_PER_P1 | 1 | | 1 (0)| 00:00:01 |
| 59 | TABLE ACCESS BY INDEX ROWID | S_ADDR_PER | 1 | 82 | 1 (0)| 00:00:01 |
|* 60 | INDEX UNIQUE SCAN | S_ADDR_PER_P1 | 1 | | 1 (0)| 00:00:01 |
| 61 | TABLE ACCESS BY INDEX ROWID | S_POSTN_CON | 1 | 33 | 1 (0)| 00:00:01 |
|* 62 | INDEX RANGE SCAN | S_POSTN_CON_M3 | 1 |
首页 上一页 3 4 5 6 7 8 下一页 尾页 6/8/8
】【打印繁体】【投稿】【收藏】 【推荐】【举报】【评论】 【关闭】 【返回顶部
分享到: 
上一篇oracle锁表解除 下一篇Oracle中SQLPLUS的常用指令收集与..

评论

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