Re: Selectivity of "=" (Re: [HACKERS] Index not used on simple se lect)

> FWIW, statisticians often seem worried about three values: the mean, median
> and mode. I don't really know which is which, but they are:
> 
> o The average of all values
> o The average of the min and max value

We have this value.  Good for > and < comparisons.

> o The most common value.

We know the number of times the most common value occurs, but not the
actual value.

> 
> Someone who knows a lot more about this stuff than me can probably tell us
> how these values will affect the trust we place in the index statistics.
> Someone on this list must be able to give us some insight???
> 
> 
> ----------------------------------------------------------------
> Philip Warner                    |     __---_____
> Albatross Consulting Pty. Ltd.   |----/       -  \
> (A.C.N. 008 659 498)             |          /(@)   ______---_
> Tel: +61-03-5367 7422            |                 _________  \
> Fax: +61-03-5367 7430            |                 ___________ |
> Http://www.rhyme.com.au          |                /           \|
>                                  |    --________--
> PGP key available upon request,  |  /
> and from pgp5.ai.mit.edu:11371   |/
> 


--  Bruce Momjian                        |  http://www.op.net/~candle maillist@candle.pha.pa.us            |  (610)
853-3000+  If your life is a hard drive,     |  830 Blythe Avenue +  Christ can be your backup.        |  Drexel Hill,
Pennsylvania19026