Subject Re: [Firebird-Architect] Inexact database operations
Author Jim Starkey
Nando Dessena wrote:

>Rick,
>
>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.
>
>
>
2^42?