Another option to make your Snowflake queries more efficient – save warehouse credits – note: there is a charge for using this optimization technique – Search Optimization

Search optimization is a premium product available with enterprise version of Snowflake and up.

https://docs.snowflake.com/en/user-guide/search-optimization-service

https://docs.snowflake.com/en/user-guide/search-optimization-service#label-search-optimization-maintenance-billing

Search optimization expedites queries that can use exact matches in the predicates (where clause).

Frequently used lookup table would be good candidates for search optimization.

Search optimization is turned on at the table level. It works by pre-building, and storing search paths that your queries can use quickly returning resultsets or a sub-result of a larger query.

Keywords: tune, optimize, performance