title: Oracle Is it necessary to gather table stats for a new table with new index?
body: <p>I just created a new table on 11gR2 and loaded it with data with no index. After the loading was completed, I created several indexes on the new table including primary constraint. </p>
  
  <pre><code>CREATE TABLE xxxx (col1 varchar2(20), ...., coln varhcar2(10));
  INSERT INTO xxxx SELECT * FROM another_table;
  ALTER TABLE xxxx ADD CONSTRAINT xxxc PRIMARY KEY(col_list);
  CREATE INDEX xxxx_idx1 ON xxxx (col3,col4);
  </code></pre>
  
  <p>AT this point do I still need to use DBMS_STATS.GATHER_TABLE_STATS(v_owner,'XXXX') to gather table stats?
  If yes, why? since Oracle says in docs "Oracle Database now automatically collects statistics during index creation and rebuild".</p>
  
  <p>I don't want to wait for automatic stats gathering over night because I need to report the actual size of the table and its index immediately after the above operations. I think running DBMS_STATS.GATHER_TABLE_STATS may give me a more accurate usage data. I could be wrong though.</p>
  
  <p>Thanks in advance,</p>