Enabled by default in Fabric Warehouse and the SQL analytics endpoint, this stores the final output of eligible SELECT queries so a repeat returns the stored output instead of recomputing. Changing any table the query uses invalidates what was stored.
Read more: Microsoft Learn
In the Ultra Transcenders books
Each book explains Result set caching in context, with comparison tables and the common traps.
Terms in this definition
- Fabric Warehouse
A relational data warehouse in the classic style, offered as a Fabric item, that supports T-SQL fully, transactions included.
- SQL analytics endpoint
Read-only SQL access in Fabric to the data in a lakehouse. Power BI using DirectQuery through it performs more slowly than Direct Lake.
- SELECT
A DML command in SQL used to retrieve rows from one table or several.
- Event
Table in Log Analytics where entries from Windows event logs are kept.