提醒:Oracle Delete Taking a Long Time 2011年04月09日

来自: We Heart Code
订阅:sagasw
演示:以MSN订阅提醒为例 订阅到哪吒,有更新提醒我
哪吒机器人提醒:
提醒:We Heart Code
【标题】Oracle Delete Taking a Long Time
【摘要】 it may look like your delete statement is hung, but ff your table has foreign keys in another table without indexes on that column oracle will full table scan that other table for every row that you’re deleting. hopefully this saves someone some time.bookmark to:
收藏 |  评论 |  推荐给好友  | 
本文共有 0 次分享
评论
共有 - 条评论


我要反馈