Fate of existing object statistics after an ANALYZE [message #1011] |
Wed, 20 March 2002 21:28 |
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
|
|
|
|