Subject Re: Poor query performance with large tables - Please help
Author Ali Gökçen
> I'd be very interested to know how you can write an aggregate query
> without the group by clause.

What is the problem with this:

select min(B),max(B),count(*)
from myTable
where A=10

Why you are fetching all A's? to be sure about to they are exactly 10?