Welcome Guest ( Log In | Register )


 
 
 
 
 
 

 
 
Oracle 

Performance Tuning Reference poster
 
Oracle training in Linux 

commands
 
Oracle training Weblogic Book
 
Easy Oracle Jumpstart
 
Oracle training & performance tuning books
 
Burleson Consulting Remote DB Administration
 
 
 
Reply to this topicStart new topic
> Update STATS
Nav Singh
post Apr 10 2008, 09:14 AM
Post #1


Member
**

Group: Members
Posts: 29
Joined: 1-April 08
From: Australia
Member No.: 20,286



Hi Guys,

Can someone please tell me what is the difference between following to commands..


EXEC DBMS_STATS.GATHER_TABLE_STATS('<Schema_name>','<Table_name>');

AND

ANALYZE table <SCHEMA_NAME>.<TABLE_NAME> compute statistics;

Thanks

Nav
Go to the top of the page
 
+Quote Post
SteveC
post Apr 10 2008, 09:56 AM
Post #2


Advanced Member
***

Group: Members
Posts: 2,836
Joined: 11-March 08
Member No.: 18,933



Analyze is the old way, starting around 8i or 9i, Oracle documentation started saying to use dbms_stats instead. Analyze is still useful, does a few things that dbms_stats doesn't. By and large, for optimizer statistics, use dbms_stats. Analyze is useful for some validation.
Go to the top of the page
 
+Quote Post

Reply to this topicStart new topic
1 User(s) are reading this topic (1 Guests and 0 Anonymous Users)
0 Members:

 

Lo-Fi Version Time is now: 24th September 2017 - 12:34 PM