dbcc-dropresultsetcache-transact-sql.md

title	DBCC DROPRESULTSETCACHE (Transact-SQL) | Microsoft Docs
ms.custom
ms.date	07/03/2019
ms.prod	sql
ms.technology	data-warehouse
ms.reviewer
ms.topic	language-reference
dev_langs	TSQL
ms.assetid	73f598cf-b02a-4dba-8d89-9fc0b55a12b8
author	XiaoyuMSFT
ms.author	xiaoyul
monikerRange	= azure-sqldw-latest || = sqlallproducts-allversions

DBCC DROPRESULTSETCACHE (Transact-SQL)

[!INCLUDEtsql-appliesto-xxxxxx-xxxx-asdw-xxx-md]

Removes all result set cache entries from an Azure [!INCLUDEssSDW] database.

Transact-SQL Syntax Conventions (Transact-SQL)

Syntax

DBCC DROPRESULTSETCACHE
[;]  

Permissions

Requires membership in the DB_OWNER fixed server role.

Remarks

• This command empties the result set cache for all queries.

• Turning OFF the result set cache feature for a database also deletes all cached results.

• Pausing a database enabled with result set caching won't delete the cached results.

See also

Performance tuning with result set caching
ALTER DATABASE SET Options (Transact-SQL)
ALTER DATABASE (Transact-SQL)
SET RESULT SET CACHING (Transact-SQL)
DBCC SHOWRESULTCACHESPACEUSED (Transact-SQL)