SQL Performance (MOSC)

MOSC Banner

Things to do after table recreation(Recreate table after archiving some old data)

edited Jul 15, 2014 5:00AM in SQL Performance (MOSC) 3 commentsAnswered

Hi,

Can somebody help me on the below analysis for Oracle 9i DB:

  1. 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?
  2. What is the diff between ESTIMATE/COMPUTE statistics.
  3. 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)

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center