Stack Exchange network consists of 183 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.
When you have a small table that you need to aggregate (< 100000 rows) the performance is more than acceptable for a simple retrieve. This has been my solution of choice after almost an hour of testing each possible ways!
