DBCC DROPRESULTSETCACHE (Transact-SQL)
Removes all result set cache entries from an Azure SQL Data Warehouse database.
DBCC DROPRESULTSETCACHE [;]
Requires membership in the DB_OWNER fixed server role.
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.