i run a stats on a partition table with using this package and parameters:
dbms_stats.gather_table_stats (ownname => 'WR', tabname => 'WR_CSE_MEM_MTH_SMRY',
cascade => TRUE,
estimate_percent => DBMS_STATS.AUTO_SAMPLE_SIZE,
method_opt=>'FOR ALL COLUMNS SIZE AUTO',
granularity => 'ALL', degree=>2);
when i checked on the dba_tab_stats_history i see that there are other partition table that the stats had collected.
is that something that the gather stats had implicitly included? and if it is how do i exclude/prevent it?
[Updated on: Wed, 19 October 2022 14:58]
Report message to a moderator