Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: why people delete statistics bore running statistics
mfullerton_at_gmail.com wrote:
> I have seen people do that as well. Running stats will generate new > stats. Deleting them is bad because it will force queries to use rule > based optimization during the time from the delete and the time the > stats for those specific tables get put back. > > On Oct 19, 4:31 pm, DA Morgan <damor..._at_psoug.org> wrote: >> dbaplusp..._at_hotmail.com wrote:
>> -- >> Daniel A. Morgan >> University of Washington >> damor..._at_x.washington.edu >> (replace x with u to respond) >> Puget Sound Oracle Users Groupwww.psoug.org
Fascinating job of editing. You left my name and signature and not a single line I wrote.
Then you top posted an incorrect conclusion. Nice!
-- Daniel A. Morgan University of Washington damorgan_at_x.washington.edu (replace x with u to respond) Puget Sound Oracle Users Group www.psoug.orgReceived on Mon Oct 23 2006 - 10:22:59 CDT