| Data Statistics [message #317780] |
Sat, 03 May 2008 07:41  |
balaji1482
Messages: 94
Registered: July 2007
Location: INDIA |
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: 15243
Registered: March 2007
Location: Nanterre, France, http://... |
Senior Member |
|
|
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]
|
|
|
|
]
Members
Search
Help
Register
Login
Home
