Home » SQL & PL/SQL » SQL & PL/SQL » dbms_stats
dbms_stats [message #18779] Thu, 14 February 2002 00:10 Go to next message
krishna
Messages: 141
Registered: October 1998
Senior Member
I know that we must use the dbms_stats package for gathering statistics, but what is the exact syntax for doing it?
Re: dbms_stats [message #18791 is a reply to message #18779] Thu, 14 February 2002 05:57 Go to previous message
Grant
Messages: 578
Registered: January 2002
Senior Member
SQL> execute dbms_utility.analyze_schema('SCHEMA_NAME','COMPUTE');
Previous Topic: B*-tree indexes
Next Topic: how to execute this function with boolean variable as input
Goto Forum:
  


Current Time: Thu Sep 23 12:30:11 CDT 2021