Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Poor perfmance after large delete
Deleting from a table (even all the rows) does not reset the high-water mark. So when you do a count(*) Oracle reads up to the HWM. Truncating the table is the only may to reset the HWM (short of recreating). There is a reasonable dicussion of HWM's in the Oracle Press Advanced Tuning book.
-- Scott Kelley (skelley_at_online.disney.com) Webmaster/Database Administrator for Disney OnlineReceived on Mon Apr 21 1997 - 00:00:00 CDT
# THIS IS A DISCLAIMER: The above statements were written by Elves.
# The above is not the position or opinion of the Walt Disney Company.