>I need a fast COUNT for my table. Is there something faster than COUNT FOR? My code is COUNT FOR empty(mydate)... :)

I've found mark & cetin answers, and sure they are in the right way, not me, but how about issue a 'seek' and then 'count while' ?.