Re:Use SQL subqueries to count distinct 50x faster
by corresation on Friday January 24, 2014 @05:43PM
(#7118696)
It's worth noting that SQL Server, presuming you've configured uniques and relationships correctly, actually runs exactly the same query plan for their first query and their last query.
I detailed this at http://dennisforbes.ca/index.php/2014/01/24/your-query-plann...