2021-07-30
请大家帮我看看这个sql语句慢在哪了?
SQL文本:
update (select a.IS_NEW_VER, a.update_time from T_DOC_RELA a inner join T_DOC_INFO b on a.doc_id = b.doc_id where a.prj_id = :1 and a.UPLOAD_NODE_ID = :2 and b.doc_name = :3 and b.doc_type = :4) t set t.IS_NEW_VER = 0, t.update_time = sysdate
------------------------------------------------------------------------------------------------------
| Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time |
------------------------------------------------------------------------------------------------------
| 0 | UPDATE STATEMENT | | | | 13 (100)| |
| 1 | UPDATE | T_DOC_RELA | | | | |
| 2 | NESTED LOOPS | | 1 | 192 | 13 (0)| 00:00:01 |
| 3 | NESTED LOOPS | | 1 | 192 | 13 (0)| 00:00:01 |
|* 4 | TABLE ACCESS BY INDEX ROWID| T_DOC_INFO | 1 | 104 | 7 (0)| 00:00:01 |
|* 5 | INDEX RANGE SCAN | IDX_DOC_NAME | 2 | | 5 (0)| 00:00:01 |
|* 6 | INDEX RANGE SCAN | IDX_DOC_RELA_DOC_ID | 1 | | 4 (0)| 00:00:01 |
|* 7 | TABLE ACCESS BY INDEX ROWID | T_DOC_RELA | 1 | 88 | 6 (0)| 00:00:01 |
------------------------------------------------------------------------------------------------------
我来答
添加附件
收藏
分享
问题补充
1条回答
默认
最新
回答交流
提交
问题信息
请登录之后查看
邀请回答
暂无人订阅该标签,敬请期待~~
墨值悬赏

评论
