Re: How Long to Update a table with 33 Million records

From: Noons <wizofoz2k_at_yahoo.com.au>
Date: Sat, 16 Aug 2003 00:12:15 +1000
Message-ID: <3f3cea5e$0$10360$afc38c87@news.optusnet.com.au>

"DOKNIK" <dominiqs_at_o2.co.uk> wrote in message news:1060945272.456304_at_ernani.logica.co.uk...

> will take to update a table with 33 million records .
> snip
> Table size - 70 million records.

Fastest growing table I've ever seen! :D Which is it?

> SQL
>
> Update Flag=Y Where DN=??????

You sure? That presumably updates just one row. Should only take a fraction of a second, given that DN is uniquely indexed.

If you got 33 million of these to run, then things will be much slower.

If you want to update 33 million rows with just one statement, then this one won't do either.

--
Cheers
Nuno Souto
wizofoz2k_at_yahoo.com.au.nospam

Received on Fri Aug 15 2003 - 09:12:15 CDT