Re: need to delete 37000000 rows

From: Mike Lee <leem_at_logica.com>
Date: Tue, 6 Nov 2001 10:27:53 -0000
Message-ID: <1005042475.165075@ernani.logica.co.uk>

If you need to delete everything from the table you could always use:

truncate table <tablename>;

"Basil Jackson" <BJackson_at_BOSGmbH.Com> wrote in message news:adec38b6.0110310343.46b4a57e_at_posting.google.com...
> I don't want to be picky, but...
>
> At 800 records per second, it should only take less than 13 hours to
> delete 37 million records. Or have I misunderstood something?
>
> 37000000 (records) / 800 (per second) = 46250 seconds
> 46250 / 3600 (secs per hour) = 12.8 hours.
Received on Tue Nov 06 2001 - 04:27:53 CST