Re: update takes to long

From: Mladen Gogala <mgogala.SPAM_ME.NOT_at_verizon.net>
Date: Sat, 17 Feb 2007 10:29:20 GMT
Message-ID: <4OABh.4294$am1.94@trndny01>

On Fri, 16 Feb 2007 21:19:55 +0100, Maxim Demenko wrote:

> Mladen, you still miss my point - both updates are not the same if
> SORTORDER is nullable (and only with COUNT is adequate to original
> statement) :

Of course, but if path (path is the critical column here) is nullable, then the application designer is a complete idiot. If, on the other hand, the path column is non-nullable, then the number of records with path smaller or equal to the given path is precisely the row number of the given record.

-- 
http://www.mladen-gogala.com

Received on Sat Feb 17 2007 - 04:29:20 CST