When I analyze partitioned tables, sometimes I get global stats and sometimes I don't. What do I need to do to get consistent returns on global stats? When I look at the DBMS_STATS.GATHER_TABLE_STATS produced by TOAD the statements are identical for partitioned tables that have global stats and tables that don't.
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center