View Single Post
 
Old February 23rd, 2005, 11:47 PM
jemacc jemacc is offline
Friend of Wrox
 
Join Date: Nov 2003
Location: Lehigh Acres, FL, USA.
Posts: 625
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to jemacc
Default

In cases of updates that have specific criteria or that return result sets not in order, having no index do not pose a problem. For updates that return ordered result sets, extra processing is needed to search the index pages that are not in order. And as far as time is concerned , if it takes a long time it is a performance issue.

You can also run your query with and without a cluster indexing and view the execution plan to measure how your updates did.


Jaime E. Maccou