Re: Question about performance of an update statement

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Uri Dimant (urid_at_iscar.co.il)
Date: 05/11/04 

Date: Tue, 11 May 2004 15:47:28 +0200

Learner
How big is your table which you are going to update?
What is an indexes defined on the table?

The rule of thumb keep your transaction short in small batches.
Yes , indexes may affect performance during the update ,especially if you
update a primary key (with CLI)of the table.
I'd go with scripting out all indexes before perfoming an update and
applying them after that.

"Learner" <wantnospam@email.com> wrote in message
news:MPG.1b0abaf47e6bdbac989724@msnews.microsoft.com...
> Hi,
>
> I have a simple update statement but it seems to be taking forever in
> Query Analyzer. My questions are:
>
> 1) Shoudl there be any performance difference if I execute the above
> update statement from Query Analyzer or via a DTS (i.e. by executing a
> 'SQL TASK')
>
> 2) How is the execution time effected if I have defined indexes? I think
> this would slow things down but would request detailed feedback from the
> experienced users
>
> --
> Thanks.

Relevant Pages