SET RESULT SET CACHING (Transact-SQL)
Applies to: Azure Synapse Analytics
Controls the result set caching behavior for the current client session.
Applies to Azure Synapse Analytics
Transact-SQL syntax conventions
Syntax
SET RESULT_SET_CACHING { ON | OFF };
Note
This syntax is not supported by serverless SQL pool in Azure Synapse Analytics.
Remarks
Run this command when connected to the user database where you want to configure the result_set_caching setting for.
ON
Enables result set caching for the current client session. Result set caching cannot be turned ON for a session if it is turned OFF at the database level.
OFF
Disable result set caching for the current client session.
Note
Result set caching should not be used in conjunction with DECRYPTBYKEY. If this cryptographic function must be used, ensure you have result set caching disabled (either at session-level or database-level) at the time of execution.
Examples
Query the result_cache_hit column in sys.dm_pdw_exec_requests with a query's request_id to see if this query was executed with a result cache hit or miss.
SELECT result_cache_hit
FROM sys.dm_pdw_exec_requests
WHERE request_id = 'QID58286'
Permissions
Requires membership in the public role
See also
Phản hồi
https://aka.ms/ContentUserFeedback.
Sắp ra mắt: Trong năm 2024, chúng tôi sẽ dần gỡ bỏ Sự cố với GitHub dưới dạng cơ chế phản hồi cho nội dung và thay thế bằng hệ thống phản hồi mới. Để biết thêm thông tin, hãy xem:Gửi và xem ý kiến phản hồi dành cho