Things to do after table recreation(Recreate table after archiving some old data)
Hi,
Can somebody help me on the below analysis for Oracle 9i DB:
- After recreating old table(create new table with recent data after archiving old data & truncate/drop the old table), what are all the things to do on a newly created table(like Gather Stats,etc) other than the Index, Constraint creation?
- What is the diff between ESTIMATE/COMPUTE statistics.
- In DBMS_STATS, gathering stats with ‘estimate_percent => 100’ will give good performance or bad performance?(For Example 100% brings the ‘sample_size’ of the table to exact rows present in table, will this cause any poor performance during SQL execution on those tables)
0