Can this update query be improved?

[micang]

hi All,

I am running the following code:

update dcd SET dcd.gvw = dcd1.gvw
FROM dcd
INNER JOIN dcd1 ON dcd.[regmark] = dcd1.[regmark]

2 tables, each 35 million rows. Both columns [regmark] are indexed, unique.

The query has been running for almost 3 hours, does this seem correct?

Also, what are the implications if I need to stop this query?

Thanks in advance.

micanguk

 

[micang]

hi Frederico,

thanks for that. the pc specs are virtually indentical. i will def. give this a go. i am not sure on the record size and will look at that once at the office.

it seems tho that this should do the trick and it's great to have some sort of reference now.

many thanks

micanguk