[rt-users] Oracle 9 and Build.html performance

[Emmanuel Lacour]

On Tue, Jan 22, 2008 at 03:26:18PM +0100, Joop wrote:
> Emmanuel Lacour wrote:
> >  
> I tried both and with compute I get better results than estimate. Have a 

I just did the same, on oracle 9 it divides the by 2 :)

Thanks very much!

> look at the docs to see other options of analyze and with atleast Oracle 
> 10g it is recommended to use DBMS_STATS.GATHER_SCHEMA_STATS or one of 
> its relatives. It has the possibility to keep the compute timewise 
> within bays. My VM took about 1min to analyze the whole schema and it 
> does so each morning at 6:00 am so  noone is bothered by it.
> 

I will look deeper in those options...