Question about performance of an update statement

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

From: Learner (wantnospam_at_email.com)
Date: 05/11/04 

Date: Tue, 11 May 2004 14:09:18 +0500

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