Azure Synapse Resultset caching – how it works?

Dedicated SQL Pool in Azure Synapse has a very interesting feature called result set caching. This mechanism is very specific to Synapse and it can significantly increase the performance of a query. In a nutshell, we can say that result set caching when enabled automatically cache query results for repetitive use. Because of this, any […]