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?

Report message to a moderator

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

Report message to a moderator

Previous Topic: B*-tree indexes
Next Topic: how to execute this function with boolean variable as input
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Aug 19 19:30:51 CDT 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.