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달 전140회 조회
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.
관련 콘텐츠
AWS 공식업데이트됨 2년 전- AWS 공식업데이트됨 5달 전
- AWS 공식업데이트됨 2년 전
thank you Ranjan for your time; what about Provisionned (I know the result caching is managed a bit differently)?