Removing some records from table in Oracle, how to get statistics (e.g. NUM_ROWS, LAST_ANALYZED) updated?

CodePudding user response：

Gather them, for example

begin
  dbms_stats.gather_table_stats('SCOTT', 'EMP');
end;
/