Re:Use SQL subqueries to count distinct 50x faster
by taspeotis on Saturday January 25, 2014 @12:34AM
(#7119978)
I tried to do a fair job in recreating your queries and techniques with MSSQL. Turns out MSSQL picks the best plan from the start [1].
[1] https://news.ycombinator.com/item?id=7119976 or http://ta.speot.is/2014/01/25/use-subqueries-to-count-distin...
Comparing across different RDBMS's is a great idea. Maybe we can squeeze it into a future blog post. :)