Does UNLOAD use result caching on Amazon Redshift
0
Hi,
when running an UNLOAD command on Amazon Redshift (or Redshift Serverless) with a SELECT statement attached to it.
Is the query benefiting the result caching mechanism available in Amazon Redshift ?
Thank you.
已提問 3 個月前檢視次數 139 次
1 個回答
- 最新
- 最多得票
- 最多評論
0
@semir I did a quick test on my serverless workgroup running the same UNLOAD multiple times but looks like in the SYS_QUERY_HISTORY result_cache_hit column was always "false". I assume this means UNLOAD will not use the result set cache.
相關內容
- 已提問 6 個月前
- 已提問 10 個月前
AWS 官方已更新 2 年前- AWS 官方已更新 1 年前
thank you Ranjan for your time; what about Provisionned (I know the result caching is managed a bit differently)?