Looking at the execution plan The update is hitting the following indexes:

1. pk_productionaudit

2. ind_productionaudit_assettime

3.ind_productionaudit_assetname

i can disable the nonclustered indexes..What about...

I followed the below method:

1) Use SELECT INTO to create a new table with the correct content by joining the two involved tables.

2) Drop the old table

3) rename the new...

Hi Stefan

i followed our steps.

The actual update is only taking 2 minutes. But creating the indexes takes 12 minutes. So in total around 14 minutes. Not a lot improvement if...

Updated 2.6 Million rows.

Total number of rows in productionaudit is 2.6 million. This is the test environment. In the live production the number of rows is >20Millions

Hi Stefan

I just diabled all the non clustered indexes and ran the update. It took 8 minutes. It is still more than the one i tested using Select * into......

Thanks Jeff for the explanation,

We do this every 3-4 months for the customers. So would like to save time and do it properly. The developer who did the work has...

Thank you guys for your responses.

I tried about 2.5 Mill rows in my test bed with the following method as suggested by stefan in the above post:

1. used select *...

I've done about 3 interviews with MS for the position of PFE - SQL. They have now invited me to the assessment day. I haven't received a written confirmation with...

Updated the statistics for the tables Cellgroupcell, productionaudit. Added the column assetdesc to the indexes u mentioned.

Grant, You are a genius. The query has come down to 6 secs with your recommendations.

Thank you.

PLease find attached table and index definations.

i have reported it.. Hopefully this will get deleted soon.

Post edited. Is it possible to delete the post?

I didn't realise i was violating the rules. i will edit the post now..

U r rite Dugi i should have given more details then just passed 70-432.. I was just excited and happy that i forgot about it.:-)

I am not sure what else...