Re: Estimate versus Compute
- From: Connor McDonald <mcdonald.connor@xxxxxxxxx>
- To: Oracle-L@xxxxxxxxxxxxx
- Date: Tue, 26 Jul 2005 09:06:17 +0800
I'm not a great fan of auto-sample-size because
a) it does more work
b) last time I checked, it can be fooled
http://www.oracledba.co.uk/tips/9i_dbms_stats.htm
I'm generally more inclined just to take segment size to determine an
dbms_stats estimate size - it naturally doesn't cover segments that
have grown and shrunk over time, but its not as if its being run all
the time anyway
hth
connor
On 7/26/05, Allen, Brandon <Brandon.Allen@xxxxxxxxxxx> wrote:
> The database with the results I mentioned earlier is version 8.0.6, so I'm
> using dbms_utility (dbms_stats didn't exist yet).
>
> I switched from this:
>
> EXECUTE dbms_utility.analyze_schema('BAAN','COMPUTE');
>
> To this:
>
> EXECUTE
> dbms_utility.analyze_schema(schema=>'BAAN',method=>'ESTIMATE',estimate_percent=>25,method_opt=>'FOR
> TABLE');
> EXECUTE
> dbms_utility.analyze_schema(schema=>'BAAN',method=>'COMPUTE',method_opt=>'FOR
> ALL INDEXES');
>
--
Connor McDonald
===========================
email: connor_mcdonald@xxxxxxxxx
web: http://www.oracledba.co.uk
"Semper in excremento, sole profundum qui variat"
--
//www.freelists.org/webpage/oracle-l
Other related posts:
