Aaah that explains it. Would this work then? select totalCount from (select count(*) as totalCount from (select * from myTable where (insertionTime BETWEEN <beginTime> and <endTime>)) where columnVal > '0' group by columnVal) where totalCount > 10;
On 10/25/05, Kurt Welgehausen <[EMAIL PROTECTED]> wrote: > > count() has always done a full table scan. As far as I know, > nothing has been done to optimize it, as your observations > seem to confirm. > > Regards >
