472,144 Members | 1,931 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,144 software developers and data experts.

slow deletes

We have a batch process that deletes about 1 million records every day
&takes about 30-35 mins to complete. Is there a way to optimize
deletes? Below is the statement

delete from fact where (key,dt) in (select key,dt from dim1 union
select key,dt from dim2)

Fact table has composite index on key,someothecolumn,dt.
>From the access plan, i see that the index is being used.
Can we implement parallel deletes or tune any other db paramaeter ? We
are on db2 udb v8.2 DPF on 10 logical nodes.

Nov 30 '06 #1
0 1024

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

16 posts views Thread by Dave Weaver | last post: by
7 posts views Thread by mp | last post: by
3 posts views Thread by jdipalmajr | last post: by
2 posts views Thread by Brock Henry | last post: by
14 posts views Thread by Michel Esber | last post: by
6 posts views Thread by Raj | last post: by
reply views Thread by Saiars | last post: by
reply views Thread by leo001 | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.