Re: estimate statistics

From: <aldenhoven_at_my-dejanews.com>
Date: Fri, 19 Jun 1998 11:36:23 GMT
Message-ID: <6mdifn$nhe$1@nnrp1.dejanews.com>

Hi,
once I was told.....

20% Estimate gives about 90% sensibility 40% gives 98% sensibility.
If jour tables are not to big, take these values. Otherwise 5% are not bad for huge tables.

This is what I heard, so handle this information with care.

Axel

In article <VMXx2HAYaWi1EweL_at_rwx777.demon.co.uk>, Steve Haynes <steve_at_rwx777.demon.co.uk> wrote:
>
> Hi All,
> RE: DBMS_UTILITY.ANALYZE_SCHEMA()
> Any thoughts on what is a sensible percentage
> to use for estimate statistics? Is 5% enough
> to allow the optimizer to make sensible decisions?
> OR I could use 10,000 rows, and that would be more rows
> than most of my dimension tables (I presume 10,000
> rows means 10,000 rows or *up to* 10,000 if that
> many exist) - However, 10,000 rows is only a tiny
> fraction of my fact table.
> Any thoughts, experiences?
> Steve
>
> --
> "The floggings will continue until morale improves."
>
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Fri Jun 19 1998 - 06:36:23 CDT