--

Nice article.

I must say however that saving intermediate results may have even a bigger impact on the performance than what you said about HAVING.

Best query optimizers today can save in-memory intermediate results and reuse them, making the HAVING clause as fast as WHERE.

But it was an interesting point, worth mentioning...

--

--

Cristian Scutaru
Cristian Scutaru

Written by Cristian Scutaru

World-class expert in Snowflake Data Cloud. Former Snowflake "Data Superhero" and SnowPro SME (Subject Matter Expert). 7x SnowPro certification exams.

No responses yet