Is updating a much more demanding task than inserting ? If so would the best
approach always be to construct the
insert sentence with joins to as much table as possible in order to avoid
updating ?

Have 3 tables with

a 5 mio
b 11 mio
c 5 mio
d 0

When inserting a/b into d it only takes about 12 minutes but when updating c
it takes 1-2 hours....?

Have tried to index felds used in the where statements (but I'm no indexing
wizard though...

/Michael v.

Michael

I think you have your answer already. Why make mutiple passes over the same
data when doing it once will work for you.

Allan

"Michael Vardinghus" wrote: