All Forums Database
preeti 15 posts Joined 05/05
18 Feb 2008
Delete ALL taking too long

DELETE FROM TABLENAME ALL;this is taking too much time . Running from past 30 mins. Total records are 1420712. Why?plz help

joedsilva 505 posts Joined 07/05
18 Feb 2008

(A) Check if this session is actually blocked (bug your DBA)If not (A) then start looking for skew, too much of indexes, triggers (who knows ?) etc .....

Jim Chapman 449 posts Joined 09/04
18 Feb 2008

Is the delete executing in ANSI transaction mode? If so, the fast delete method is not used. The use of certain table options, such as permanent journals or replication, can also make delete operations slower.

rgs 106 posts Joined 02/07
18 Feb 2008

If this is an ANSI SQL session to force it to use the fast delete method you have to submit the DELETE ALL and COMMIT as one request. DELETE FROM TABLENAME ALL; COMMIT;

preeti 15 posts Joined 05/05
20 Feb 2008

Thanks,I have bugged my DBA . He did something and now its running fine.Thanks a lot for ur suggestions.

You must sign in to leave a comment.