Welcome Guest ( Log In | Register )



Performance Tuning Reference poster
Oracle training in Linux 

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


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>');


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


Go to the top of the page
+Quote Post
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: 30th May 2017 - 02:26 AM