Subject Re: [firebird-support] Re: If Not SELECT COUNT(*), Then What?
Author Woody
From: "Dimitry Sibiryakov" <sd@...>
>> But please, do not discount nor alienate those of us who use it
>> legitimately
>> because there is no other way to get the information needed.
>
> But, actually, there is. You can get approximate record count from
> statistic.

You can't get an accurate count, that's the point. I don't want an
approximate count of the number of transactions I've had at my bank last
month, I want an exact one.

Using the statistics can only get you close. When you are running a report
that has to show statistical information for whatever reason, an approximate
count just doesn't cut it.

When you're showing a progress bar, sure, it doesn't really matter as much,
but there are many legitimate reasons for needing an exact count.

Woody (TMW)