Either add indices or why dont you export the good rows, drop the table
and then import replace_create with the output from the export.



Dan Callahan IT Specialist
603-472-4121 t/l 525-4121
[Email address protected]
[Email address protected]




"L Dba "
<db2udbdba-ezmlms
hield-x56418554.x To
[Email Address Removed] "LazyDBA Discussion"
a.com> <[Email address protected]
cc
07/14/2004 10:09
AM 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