https://teej.ghost.io/understanding-the-snowflake-query-optimizer/
Understanding the Snowflake Query Optimizer
Sep 18, 2022
“The job of a query optimizer is to reduce the cost of queries without changing what they do…. Query optimizers aren’t unique to Snowflake, any serious database has one.”