Home » RDBMS Server » Performance Tuning » COMPUTE and ESTIMATE
COMPUTE and ESTIMATE [message #65899] Tue, 25 January 2005 11:18 Go to next message
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 messageGo to next message
Frank Naude
Messages: 4565
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
Re: COMPUTE and ESTIMATE [message #65946 is a reply to message #65923] Fri, 04 February 2005 10:27 Go to previous message
lily
Messages: 44
Registered: September 2000
Member
Thanks a lot Frank.

regards,
Lily.
Previous Topic: performance tunning
Next Topic: Output display
Goto Forum:
  


Current Time: Tue Sep 22 07:36:29 CDT 2020