Home » SQL & PL/SQL » SQL & PL/SQL » compute statistics
compute statistics [message #40826] Thu, 07 November 2002 08:45 Go to next message
srs
Messages: 5
Registered: March 2002
Junior Member
Do you have to delete statistics after analysing all the tables ?

Any help is appreciated.

SRS

Report message to a moderator

Re: compute statistics [message #40842 is a reply to message #40826] Thu, 07 November 2002 09:49 Go to previous messageGo to next message
Todd Barry
Messages: 4819
Registered: August 2001
Senior Member
Why would you want to immediately delete the statistics you just gathered on the analyze? That is the whole point of running the analyze command.

Report message to a moderator

Re: compute statistics [message #40844 is a reply to message #40842] Thu, 07 November 2002 10:05 Go to previous message
srs
Messages: 5
Registered: March 2002
Junior Member
I get the point. But after a couple of days do you delete the statistics before computing statistics again ?

Report message to a moderator

Previous Topic: Update one column - multiple rows
Next Topic: connect asp program with oracle
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Apr 29 06:12:10 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.