Subject | Re: [Firebird-Architect] Inexact database operations |
---|---|
Author | Jim Starkey |
Post date | 2005-06-30T11:17:28Z |
Nando Dessena wrote:
>Rick,2^42?
>
>R> This has been brought up before. If it were implemented,
>R> APPROXIMATE_COUNT would probably always return 42.
>
>I'd try to be a little more pragmatic. Something that returns the
>order of magniture of the record count of a huge dataset has its uses.
>AFAIK that's what the optimizer does to estimate relation cardinality.
>
>
>