Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

CBO and Update Statistics

549855Mar 3 2009 — edited Mar 3 2009

Hi ,
Ver. 10204

The cbo usually working very well when it have an update statistics ,
Orcale also recommand to manually gather statistics after bulk loading.
Could one show simple TEST CASE where oracle is choosing a poor execution plan due to non update statistics?

Thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 31 2009

Added on Mar 3 2009

#general-database-discussions

1 comment

314 views