GLOBAL V/S LOCAL Stats
673580Dec 10 2008 — edited Dec 11 2008When 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?