Re: 100% CPU Util on Simple Update Query

From: Hugo Kornelis (hugo_at_pe_NO_rFact.in_SPAM_fo)
Date: 02/09/05

Date: Wed, 09 Feb 2005 22:20:29 +0100

On Wed, 9 Feb 2005 07:59:06 -0800, Joel H wrote:

(snip)
>There is no WHERE clause. Even in the original statement, all of the work is
>done on one row at a time.
(snip)

Hi Joel,

You're contradicting yourself -- if there is no WHERE clause, you're
working on all rows in the table at once, not one at a time.

Best, Hugo

-- 
(Remove _NO_ and _SPAM_ to get my e-mail address)

Relevant Pages

Re: And copyright in Europe goes to..... 70 years
... one that is codified by law and by international treaty. ... Umm, Article I, Section 8, Clause 8: ...
(rec.music.classical.recordings)
Re: Something for newbies (like myself) to consider
... "kpg" wrote in message ... You lose the weird happenings game. ... my SQL server decided it didn't want to process the ORDER BY clause. ...
(microsoft.public.cert.exam.mcse)
Re: And copyright in Europe goes to..... 70 years
... The concept of intellectual property is one that is codified by law and by international treaty. ... Umm, Article I, Section 8, Clause 8: ...
(rec.music.classical.recordings)
Re: Reading a file...
... all of your advices and this is the result: ... snip long extended code ... ... clause, arrange to have the short clause first. ...
(comp.lang.c)
Re: online C programming test
... Peter Pichler wrote: ... > there a clause in GPL that I missed that says that the source must be ...
(comp.lang.c)