Home » RDBMS Server » Performance Tuning » difference between analyze table and dbms_stats.gatherstatistic
difference between analyze table and dbms_stats.gatherstatistic [message #395751] Thu, 02 April 2009 09:21 Go to next message
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
Re: difference between analyze table and dbms_stats.gatherstatistic [message #395754 is a reply to message #395751] Thu, 02 April 2009 09:24 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: difference between analyze table and dbms_stats.gatherstatistic [message #395755 is a reply to message #395751] Thu, 02 April 2009 09:25 Go to previous message
BlackSwan
Messages: 25033
Registered: January 2009
Location: SoCal
Senior Member
visit http://tahiti.oracle.com & RTFM to see how Oracle describes them.
Previous Topic: 'show parameter allow' doesnt work
Next Topic: Temp Tablespace usage
Goto Forum:
  


Current Time: Sat Dec 03 10:01:52 CST 2016

Total time taken to generate the page: 0.16859 seconds