OraFAQ Forum: Performance Tuning » difference between analyze table and dbms

Home » RDBMS Server » Performance Tuning » difference between analyze table and dbms_stats.gatherstatistic

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

difference between analyze table and dbms_stats.gatherstatistic [message #395751]

Thu, 02 April 2009 09:21

rituraj
Messages: 18
Registered: April 2009
Location: INDIA

Junior Member

hi.
i want to know difference between ANALYZE TABLE command ane DBMS_STATS.GATHER_STATISTICS. except that analyze table is sql command and dbms_stats package. i want to know in depth difference between this two commands.
thank you

Report message to a moderator

Re: difference between analyze table and dbms_stats.gatherstatistic [message #395754 is a reply to message #395751]

Thu, 02 April 2009 09:24

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

You must use dbms_stats to gather statistics, analyze is kept for backward compatibility and is not up to date for this purpose.
Only use analyze for its other purposes than gathering statistics.

Regards
Michel

Report message to a moderator

Re: difference between analyze table and dbms_stats.gatherstatistic [message #395755 is a reply to message #395751]

Thu, 02 April 2009 09:25

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

visit http://tahiti.oracle.com & RTFM to see how Oracle describes them.

Report message to a moderator

Previous Topic:	'show parameter allow' doesnt work
Next Topic:	Temp Tablespace usage

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 22 18:02:00 CST 2024