oracle DBMS_STATS.GATHER_TABLE_STATS

The Oracle RDBMS allows you to collect statistics of many different kinds as an aid to improving performance. DBMS_STATS┬ápackage is concerned with optimizer statistics only. Given that Oracle sets automatic statistics collection of this kind on by default, DBMS_STATS package is intended for only specialized cases. For GATHER_TABLE_STATS Most enterprise databases, Oracle included, use a…