SQL Performance (MOSC)

MOSC Banner

Analyze partition table

edited Sep 11, 2013 12:23AM in SQL Performance (MOSC) 5 commentsAnswered
 Hello,I have a GL table(F0911) with range partition based on gldate and 20 indexes are there.the table  size of  F0911  is 85.414 GB and record count is 54118089 rows.

out of following option,which is the recommend analyze table with less elapsed time.

analyse table crpdta.f0911 compute statistics; -----------time consuming

or 


analyse table crpdta.f0911 estimate statistics sample 20 percent;-

or
analyze each partition like

exec dbms_stats.gather_table_stats('CRPDTA','F0911','F0911_2004');
exec dbms_stats.gather_table_stats('CRPDTA','F0911','F0911_2005'); and so on

please advise

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