DBMS_STATS - non-partition table - how to gather stats without GLOBAL stats?
I am trying to gather stats on a data load table as follows and it is some how gathering GLOBAL stats which I don't want. not sure what changed.
exec DBMS_STATS.GATHER_TABLE_STATS(user,'T_STAGE_LOAD' ,estimate_percent => 35 ,degree =>4,CASCADE => FALSE);
OWNER, TABLE_NAME, NUM_ROWS, SAMPLE_SIZE, LAST_ANALYZED, GLOBAL_STATS
PROD, TABLE_DBMS_STATS, 1000, 1000,10/7/2010 10:36:31 PM,YES
PROD,T_STAGE_LOAD,8530940,2985829,10/7/2010 6:30:36 PM,YES
I also tried the following test on a small test table but Oracle still gathering GLOBAL stats:
DELETE stats: exec dbms_ddl.analyze_object(type => 'TABLE', schema => 'RXERPROD', name => 'TABLE_DBMS_STATS', method => 'DELETE')
exec DBMS_STATS.GATHER_TABLE_STATS(user,'T_STAGE_LOAD' ,estimate_percent => 35 ,degree =>4,CASCADE => FALSE);
OWNER, TABLE_NAME, NUM_ROWS, SAMPLE_SIZE, LAST_ANALYZED, GLOBAL_STATS
PROD, TABLE_DBMS_STATS, 1000, 1000,10/7/2010 10:36:31 PM,YES
PROD,T_STAGE_LOAD,8530940,2985829,10/7/2010 6:30:36 PM,YES
I also tried the following test on a small test table but Oracle still gathering GLOBAL stats:
DELETE stats: exec dbms_ddl.analyze_object(type => 'TABLE', schema => 'RXERPROD', name => 'TABLE_DBMS_STATS', method => 'DELETE')
0