COMPUTE and ESTIMATE [message #65899] |
Tue, 25 January 2005 11:18 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
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 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
Frank Naude
Messages: 4580 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
|
|
|
|