https://docs.snowflake.com/en/user-guide/warehouses-considerations.html#scaling-up-vs-scaling-out. At the "tip" it states: ... which CAN impact performance ...
"Decreasing the size of a running warehouse removes compute resources from the warehouse. When the computer resources are removed, the cache associated with those resources is dropped, which can impact performance in the same way that suspending the warehouse can impact performance after it is resumed."
https://docs.snowflake.com/en/user-guide/warehouses-considerations
Decreasing the size of a running warehouse removes compute resources from the warehouse. When the computer resources are removed, the cache associated with those resources is dropped, which can impact performance in the same way that suspending the warehouse can impact performance after it is resumed.
B. Yes, because the compute resource is replaced in its entirety with a new compute resource.
When a Snowflake warehouse is resized, the current compute resources are replaced with new ones. This process clears the existing cache, and thus the cached data will be lost during the resizing operation.
Decreasing the size of a running warehouse removes compute resources from the warehouse. When the computer resources are removed, the cache associated with those resources is dropped, which can impact performance in the same way that suspending the warehouse can impact performance after it is resumed.
Keep this in mind when choosing whether to decrease the size of a running warehouse or keep it at the current size. In other words, there is a trade-off with regards to saving credits versus maintaining the cache.
Answer is A
Decreasing the size of a running warehouse removes compute resources from the warehouse. When the computer resources are removed, the cache associated with those resources is dropped, which can impact performance in the same way that suspending the warehouse can impact performance after it is resumed.
my bad : Decreasing the size of a running warehouse removes compute resources from the warehouse. When the computer resources are removed, the cache associated with those resources is dropped, which can impact performance in the same way that suspending the warehouse can impact performance after it is resumed.
so means possibly yes if it got reducerd so A is correct
https://docs.snowflake.com/en/user-guide/warehouses-considerations
Decreasing the size of a running warehouse removes compute resources from the warehouse. When the computer resources are removed, the cache associated with those resources is dropped, which can impact performance in the same way that suspending the warehouse can impact performance after it is resumed.
Keep this in mind when choosing whether to decrease the size of a running warehouse or keep it at the current size. In other words, there is a trade-off with regards to saving credits versus maintaining the cache.
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
William_20
Highly Voted 2 years, 8 months agoPrasantSadangi
1 month, 1 week agostornati
2 years, 5 months agod22770a
7 months agoBobFar
1 year, 6 months agod22770a
Most Recent 7 months agoMallikharjuna452
9 months, 3 weeks agopranalig
10 months, 3 weeks agosambathchandran
11 months, 1 week agoPrashn
1 year, 2 months ago_yyukta
1 year, 2 months agosandy91
1 year, 3 months agoMarge23
1 year, 7 months agoMultiCloudIronMan
1 year, 9 months agoHopefan
1 year, 11 months agoHopefan
1 year, 11 months agolearner2023
2 years agoKarBiswa
2 years, 2 months agobaig123
2 years, 4 months agodb1290
2 years, 5 months ago