You'd better create a new table instead of delete that volume of the rows
from that table.

----- Original Message -----
From: "L Dba " <db2udbdba-ezmlmshield-x56418554.[Email address protected]
To: "LazyDBA Discussion" <[Email address protected]
Sent: Wednesday, July 14, 2004 10:09 PM
Subject: Slow deletes


> Hi all,
>
> We are attempting to delete 5.7 million rows from an 8.1 million row table
that only contains a primary key index using the following delete statement:
>
> delete from tablename where nonindexed_field in (1, 2, 3) and
nonindexed_field > 8
>
> This command has now been running for more than 26 hours. All foreign
keys that accessed the table were dropped previously. We were able to
select the data before the delete started using the following statement:
>
> select * from tablename where nonindexed_field in (1, 2, 3) and
nonindexed_field > 8
>
> This query took less than 3 minutes to return the full data set.
>
> Can anyone give me any tips on how to troubleshoot this issue? What could
be slowing down this delete?
>
> Thanks In Advance,
> D
>
>
> ---------------------------------------------------------------------
> PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
> website: http://www.LazyDBA.com
> To unsubscribe: http://www.lazydba.com/unsubscribe.html
> For additional commands, e-mail: db2udbdba-[Email address protected]
>
>



DB2 & UDB email list listserv db2-l LazyDBA home page