OraFAQ Forum: Performance Tuning » Why not use analyze?

Home » RDBMS Server » Performance Tuning » Why not use analyze?

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

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

Report message to a moderator

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.

Report message to a moderator