| COMPUTE and ESTIMATE [message #65899] |
Tue, 25 January 2005 11:18  |
lily
Messages: 44
Registered: September 2000
|
Member |
|
|
analyze table xxx estimate statistics;
analyze table xxx compute statistics;
-- which one gives more performance and less bottleneck?
regards,
Lily.
|
|
|
|
| Re: COMPUTE and ESTIMATE [message #65923 is a reply to message #65899] |
Tue, 01 February 2005 04:04  |
Frank Naude
Messages: 4595
Registered: April 1998
|
Senior Member |
|
|
Hi,
Generally "compute statistics" is more resource intensive while running, but it will gather better stats and allow the optimizer to make better decisions.
"Estimate statistics" is less resource intensive, but may cause the optimizer to choose bad query plans afterwards.
Best regards.
Frank
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
