Help required in table reorg
Hi All,
I could see some recommendation in LOG_TABLE_REORG as reorg program were run with "Q" (Quick Check) parameter.
Those recommendation includes some temp table also.
High recommendation: Gather statistics with estimate_percent = dbms_stats.auto_sample_size on XXXXXXX
--this recommendation has been given to below tables,
ENG_<host>_IN, ENG_<host>_OUT, DEM_APPSERV_IN, DEM_APPSERV_OUT
T_SRC_ITEM_TMPL_TMP, T_SRC_LOC_TMPL_TMP, T_SRC_SALES_TMPL_TMP
T_DATE_15749_751_638868369
Is it necessary to run Gather stats on those temp and staging tables?
Below recommendations given to promotion_data table.
Recommendation: Based on NULL column distribution of table PROMOTION_DATA, run thorough check