dbcc-dropresultsetcache-transact-sql.md

title	DBCC DROPRESULTSETCACHE (Transact-SQL)
description	DBCC DROPRESULTSETCACHE removes all result set cache entries from an Azure Synapse Analytics database.
author	mstehrani
ms.author	emtehran
ms.reviewer	wiassaf, randolphwest
ms.date	12/05/2022
ms.service	sql
ms.subservice	data-warehouse
ms.topic	reference
dev_langs	TSQL
monikerRange	= azure-sqldw-latest

DBCC DROPRESULTSETCACHE (Transact-SQL)

[!INCLUDE asa]

Removes all result set cache entries from an [!INCLUDEssazuresynapse-md] database.

:::image type="icon" source="../../includes/media/topic-link-icon.svg" border="false"::: Transact-SQL syntax conventions

Syntax

DBCC DROPRESULTSETCACHE
[;]

Note

[!INCLUDEsynapse-analytics-od-unsupported-syntax]

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)