>I need a fast COUNT for my table. Is there something faster than COUNT FOR? My code is COUNT FOR empty(mydate)... :)
To ensure that you getRushmore optimisation, you would need an index on EMPTY( mydate). If you already have an index on mydate, you could change your test to
COUNT FOR mydate = {}