Re: delete statement performance

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Tue, 14 Dec 1999 22:01:41 +0800
Message-ID: <38564DC5.62B1@yahoo.com>

NJDave65 wrote:
>
> If you don't mind losing the data perm., can you try truncate? them it doesn't
> have to write to the rollback segment.

I think the original poster is trying to delete a single row from a large table, not all the rows...

Cheers
--

---

Connor McDonald
"These views mine, no-one elses etc etc" connor_mcdonald_at_yahoo.com

"Some days you're the pigeon, and some days you're the statue." Received on Tue Dec 14 1999 - 08:01:41 CST