DBCC DROPRESULTSETCACHE (Transact-SQL)

Applies to: Azure Synapse Analytics

Removes all result set cache entries from an Azure Synapse Analytics database.

Transact-SQL syntax conventions

Syntax

DBCC DROPRESULTSETCACHE
[;]

Note

This syntax is not supported by serverless SQL pool in Azure Synapse Analytics.

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)