DBCC DROPRESULTSETCACHE (Transact-SQL)

APPLIES TO: noSQL Server noAzure SQL Database yesAzure Synapse Analytics (SQL DW) noParallel Data Warehouse

Removes all result set cache entries from an Azure SQL Data Warehouse database.

Topic link icon 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)