Home » RDBMS Server » Performance Tuning » Why not use analyze?
Why not use analyze? [message #65572] Mon, 01 November 2004 13:58 Go to next message
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 Go to previous messageGo to next message
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.
Re: Why not use analyze? [message #65574 is a reply to message #65573] Mon, 01 November 2004 16:47 Go to previous messageGo to next message
IA
Messages: 91
Registered: March 2004
Member
Hi Bruce,

What do you mean by 'not expanding'?

Thanks ... IA
Re: Why not use analyze? [message #65575 is a reply to message #65574] Mon, 01 November 2004 17:10 Go to previous messageGo to next message
Bruce McCartney
Messages: 7
Registered: September 2004
Junior Member
well, if oracle decides to keep another statistic that it doen't keep now - analyze won't calculate it...
Re: Why not use analyze? [message #65584 is a reply to message #65572] Tue, 02 November 2004 23:02 Go to previous message
DUncan SLater
Messages: 1
Registered: November 2004
Junior Member
where can you find the gather_system_stats supplied procedure?
Previous Topic: testing performance of queries
Next Topic: URGENT:-Problem due to Remote access of a Table in SQL
Goto Forum:
  


Current Time: Thu Mar 28 16:59:28 CDT 2024