Skip to Main Content

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!

GLOBAL V/S LOCAL Stats

673580Dec 10 2008 — edited Dec 11 2008
When does Oracle uses GLOBAL level statistics and when does it uses PARTITION level stats?

e.g. I know if I say PART_KEY = 10 then it will use Partition level stats.. and when I don't specify part_key in SQL, it will use global stats... Looking for all other scenarios where it will use one or other?
This post has been answered by Randolf Geist on Dec 11 2008
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 8 2009
Added on Dec 10 2008
3 comments
939 views