Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Optimizer behavior
We have a database set to CHOOSE. Although we would like to
run compute statistics weekly on a particular schema's tables,
it takes too long. If we were to do compute statistics once
per month and estimate statistics weekly, would that be efficient?
When estimate statistics is done is it overriding all of the
statistics from compute statistics?