Re: "Delete From <table>" taking all day
From: Vince Germscheid <Vince_Germscheid_at_cscmail.csc.com>
Date: 1996/08/24
Message-ID: <01bb91bf$0fd4b580$1f1e0814_at_vgermscheid.min.csc.com>#1/1
Date: 1996/08/24
Message-ID: <01bb91bf$0fd4b580$1f1e0814_at_vgermscheid.min.csc.com>#1/1
Bill Meskill <meskillw_at_ncr.disa.mil> wrote in article
<4vcbp9$6a3_at_lal.interserv.com>...
> Hi,
> I have a 4000 row table that's taking quite a long
> time to delete. What's going on?
>
The quickes way to clear a table is to use the TRUNCATE command which uses
no rollback space, it also does NOT allow for ROLLBACK so use cautiously.
The delay in deleting from this table could be cause by:
- Log file switching
- Cascading deletes if used
- Inadequate RBS space
- Locks being held by other users
V> Received on Sat Aug 24 1996 - 00:00:00 CEST