|Subject||Re: [Firebird-Architect] Inexact database operations|
Nando Dessena wrote:
>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.