| Data Statistics [message #317780] |
Sat, 03 May 2008 07:41  |
balaji1482
Messages: 312
Registered: July 2007
Location: INDIA
|
Senior Member |
|
|
hi all,
EXECUTE DBMS_STATS.GATHER_SCHEMA_STATS( OWNNAME => ,METHOD_OPT=> 'FOR ALL INDEXED COLUMNS SIZE 1', GRANULARITY=> 'DEFAULT', DEGREE =>, CASCADE => TRUE);
DBMS_UTILITY.compile_schema('schema')
The above 2 packages is used to collect statistics for a partitcular schema.what is the main differences in these 2 packages ?
|
|
|
|
| Re: Data Statistics [message #317786 is a reply to message #317780] |
Sat, 03 May 2008 09:34  |
 |
Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
|
Senior Member
Account Moderator |
|
|
One gather statistics, the other one compile procedures.
Just read the few first lines of procedure descriptions in documentation.
Regards
Michel
[Edit missing "read" word]
[Updated on: Mon, 05 May 2008 06:59] Report message to a moderator |
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
