Dimitry,

>> 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.
>
> And what does prevent you from getting the count by report builder's
> remedies? Brain fade?

Cool it :-) Have a drink...

What would "report builders remedies" be? Fetching all rows and getting
it's count? That will probably take even longer :-)

Woody said he only needs the count itself, not the details of the data...

And as was said too, the qualified count isn't the problem.



With regards,

Martijn Tonies
Upscene Productions
http://www.upscene.com

Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
Anywhere, MySQL, InterBase, NexusDB and Firebird!

Database questions? Check the forum:
http://www.databasedevelopmentforum.com