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... _______________________________________________ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
