469,934 Members | 1,974 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,934 developers. It's quick & easy.

slow deletes

Raj
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.
Thanks
Raj

Nov 30 '06 #1
0 976

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
By using this site, you agree to our Privacy Policy and Terms of Use.