Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Poor perfmance after large delete

Re: Poor perfmance after large delete

From: Scott Kelley <skelley_at_online.disney.com>
Date: 1997/04/21
Message-ID: <335BBE8C.6781@online.disney.com>#1/1

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 Online
	

# THIS IS A DISCLAIMER: The above statements were written by Elves.
# The above is not the position or opinion of the Walt Disney Company.
Received on Mon Apr 21 1997 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US