Kevin Wilkie is implicit in this whole thing:
One of the ways we can get better at speed is to attempt several slightly different ways that can get you (hopefully) the same data. Some tables work better with one query while some work better with another query.
Let’s work through a scenario in Snowflake and we’ll see which one is faster under “normal” conditions.
Click through for a few query examples and how they end up performing.