Home » SQL & PL/SQL » SQL & PL/SQL » Fate of existing object statistics after an ANALYZE
Fate of existing object statistics after an ANALYZE [message #1011] Wed, 20 March 2002 21:28 Go to next message
Cameron Paroz
Messages: 1
Registered: March 2002
Junior Member
Senario
On the weekend outage the db tables are analyzed with the command "ANALYZE TABLE X ESTIMATE STATISTICS SAMPLE 30 PERCENT" for all tables.

Throughout the week a nightly task performs further analyzing using the "ANALYZE TABLE X ESTIMATE STATISTICS SAMPLE 10000 ROWS" for each table.

Tables vary in size from 1 to 400,000,000 rows.

My question is:- Are the statisitcs calculated/stored in the data dictionary from the weekend's analyzing a. Totally overwritten by the week day analyzing or b. Considered along with the week day analyzing and any delta (change) reflected back into the data dictionary.

I am getting varying opinions on what exactly happens, therefore any help is appreciated.

Thanks
Cameron Paroz
Re: Fate of existing object statistics after an ANALYZE [message #1018 is a reply to message #1011] Thu, 21 March 2002 04:37 Go to previous message
Grant
Messages: 578
Registered: January 2002
Senior Member
The statistics are overwritten for each object analyzed every time you run analyze.
Previous Topic: How to drop table in After Report Trigger in Reports?
Next Topic: Re: varchar=numeric in where clause
Goto Forum:
  


Current Time: Thu Mar 28 14:27:38 CDT 2024