| Why not use analyze? [message #65572] |
Mon, 01 November 2004 13:58  |
IA
Messages: 91
Registered: March 2004
|
Member |
|
|
Hi Everyone,
Oracle recommends not using the analyze command, but rather, use the gather_schema_stats and gather_system_stats supplied procedures.
What is the advantage of doing so and why is this Oracle's recommendation?
Thanks ... IA
|
|
|
|
| Re: Why not use analyze? [message #65573 is a reply to message #65572] |
Mon, 01 November 2004 14:54  |
Bruce McCartney
Messages: 7
Registered: September 2004
|
Junior Member |
|
|
|
the gather_stats can gather in parallel, and stats gathered by analyze are not expanding; gather_stats does and will (depending on oracle version) get stats used by the optimizer that the analyze command never will.
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
