Re: "Delete From <table>" taking all day

Gary Assa wrote:
>
> >>I have a 4000 row table that's taking quite a long
> >>time to delete. What's going on?
 

> >>Bill Meskill
> >
> It could also be that you delete/update/inserted into the table, shelled out
> and started up a new SQL session. Your previous session would have a lock on
> the table. Or someonle else could have a lock. You said only 2 people on server
> but is someone in a Form across the network accessing the table. Many
> possibilities...
> --

Oracle deletes actually have to do a lot of work to allow for the possibility of a rollback by the user.

If you are deleting all rows in the table use TRUNCATE instead. It is much, much faster but does not permit rollback.

Dave Roth

> =========================================================
> http://www.li.net/~gsa/index.html
> This is my signature file, not part of this mail message.
Received on Thu Aug 22 1996 - 00:00:00 CEST