This discussion is archived
4 Replies Latest reply: Mar 19, 2013 7:00 PM by Hemant K Chitale RSS

EXEC DBMS_STATS.GATHER_TABLE_STATS

saswat. Newbie
Currently Being Moderated
what sample was implicitly taken when we run
EXEC DBMS_STATS.GATHER_TABLE_STATS('owner_name','table_name',cascade=>TRUE);

Oracle 9.2.0 database..
table size is 256Gb – Partitioned table consisting 26 partitions

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points