Well, coming from complete ignorance of your volumes, and what "cost" means here, my typical brute force recommendation.

Build a memory table comprised of all (or all active) account numbers + status (presumably a single digit) and join to it when you want data by status. Hell, build it new every time you run stats. Can it be that costly?