Snowflake optimization