Re: Long running update

# akash.garg@gmail.com / 2005-08-11 16:17:09 -0700:
> Hello,
> I currently running an update statement that updates every row in a
> very large table.  This query will obviously take a long time to run.
> My question -- is there any way to know how much time it will take
> once it starts?  Even something that could help me approximate the
> speed at which it's doing the update would be helpful.

    Yeah, it would be nice if select, insert, update, delete could
    be set to log their progress at configured intervals.

--
How many Vietnam vets does it take to screw in a light bulb?
You don't know, man.  You don't KNOW.
Cause you weren't THERE.             http://bash.org/?255991