暂无图片
请大家帮我看看这个sql语句慢在哪了?
我来答
分享
清晨到日暮
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条回答
默认
最新
QIU飞

可以用merge into

暂无图片 评论
暂无图片 有用 0
回答交流
提交
问题信息
请登录之后查看
邀请回答
暂无人订阅该标签,敬请期待~~
暂无图片墨值悬赏