SQL> DROP TABLE WITHOUT_STATS;
 
Table dropped
SQL> CREATE TABLE WITHOUT_STATS(id NUMBER,col1 VARCHAR2(255))
  2  /
 
Table created
SQL> BEGIN
  2  FOR v_indx IN 1..100 LOOP
  3  	INSERT INTO WITHOUT_STATS VALUES(v_indx,'Description for '||v_indx);
  4  END LOOP;
  5  COMMIT;
  6  END;
  7  /
 
PL/SQL procedure successfully completed
SQL> SELECT TABLE_NAME ,NUM_ROWS FROM ALL_TABLES WHERE TABLE_NAME ='WITHOUT_STATS';
 
TABLE_NAME                       NUM_ROWS
------------------------------ ----------
WITHOUT_STATS                  
SQL> BEGIN
  2  	DBMS_STATS.GATHER_TABLE_STATS(USER,'WITHOUT_STATS');
  3  END;
  4  /
 
PL/SQL procedure successfully completed
SQL> SELECT TABLE_NAME ,NUM_ROWS FROM ALL_TABLES WHERE TABLE_NAME ='WITHOUT_STATS';
 
TABLE_NAME                       NUM_ROWS
------------------------------ ----------
WITHOUT_STATS                         100
 
SQL>