Re: update takes to long

Mladen Gogala schrieb:
> On Fri, 16 Feb 2007 06:12:22 -0800, andersleffler wrote:
>

>> UPDATE a
>>    SET (sortorder) = (SELECT COUNT (sortorder)
>>                       FROM a b
>>                      WHERE b.PATH <= a.PATH)

You should have added "Not tested" ;-)

Best regards

Maxim Received on Fri Feb 16 2007 - 11:08:40 CST