gather stats on tables with stale stats < 10%
whenever i have a sql performance issue ..i generally run SQLT xtract and one of areas i see is "Observations".Most of the times SQLT suggests to consider gathering stats on tables using
estimate_percent => DBMS_STATS.AUTO_SAMPLE_SIZE,
even though there are no stale statistics on the indexes or tables or the modifications on those tables are less than 5%.
Is it really beneficial by anyways to collect gathering stats in such case?