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, 2 months agostornati
1 year, 12 months agod22770a
1 month, 1 week agoBobFar
1 year, 1 month agod22770a
Most Recent 1 month, 1 week agoMallikharjuna452
4 months agopranalig
5 months agosambathchandran
5 months, 2 weeks agoPrashn
8 months, 2 weeks ago_yyukta
8 months, 3 weeks agosandy91
10 months agoMarge23
1 year, 2 months agoMultiCloudIronMan
1 year, 4 months agoHopefan
1 year, 6 months agoHopefan
1 year, 6 months agolearner2023
1 year, 7 months agoKarBiswa
1 year, 9 months agobaig123
1 year, 11 months agodb1290
1 year, 11 months ago