Use Subqueries to Count Distinct 50X Faster
periscope.io
periscope.io
As SQL developers we should be abstracted away from performance considerations as the database engine (and its developers) should know better than us how to optimize data retrieval. I find selecting indexes to be a 90s hang up that we haven't yet let go of.