How do I remove a table's statistics preferences?
Hi,
We had estimate_percent set at 30% for some very large tables where the sample_size was way too small (below 1%).
However, we are currently migrating to 12c and tested a schema migration recently. We found out that the stats table preferences had migrated too.
DBMS_STATS.GET_PREFS('ESTIMATE_PERCENT','<SCHEMA>','<TEST_TABLE>')
--------------------------------------------------------------------------------
30.000000
1 row selected.
How do I remove this completely?
Note that DBMS_STATS.RESET_GLOBAL_PREF_DEFAULTS; only impact global settings and doesn't change the tables or schema settings.
Thank you