EXEC DBMS_STATS.GATHER_TABLE_STATS(‘<user>’, ‘<table_name>’, estimate_percent => NULL, cascade => TRUE);
Instead of estimating the statistics using a given percentage, this will hit all rows.
November 23, 2016
Comments Off on Compute Statistics
EXEC DBMS_STATS.GATHER_TABLE_STATS(‘<user>’, ‘<table_name>’, estimate_percent => NULL, cascade => TRUE);
Instead of estimating the statistics using a given percentage, this will hit all rows.