Immetti i tuoi dati per iscriverti al blog su Microsoft Fabric.

Grazie per aver effettuato l'iscrizione al blog su Microsoft Fabric. Riceverai notifiche via e-mail quando pubblichiamo nuovi post.

Microsoft Fabric Updates Blog

  1. Aggiornamenti
  2. Emily Tehrani

Proactive and incremental statistics refresh for Fabric Data Warehouse and SQL Analytics Endpoint

In December, we released two new optimizations for statistics maintenance in the Fabric Data Warehouse and the SQL Analytics Endpoint: Proactive Statistics Refresh and Incremental Statistics Refresh. These features help keep query optimizer statistics aligned with how your data changes over time, leading to quicker query plan generation, less regressions after ingestion, and further minimizing the need for manual statistic maintenance.

Result Set Caching for Microsoft Fabric Data Warehouse (Preview)

Result Set Caching is now available in preview for Microsoft Fabric Data Warehouse and Lakehouse SQL analytics endpoint. This performance optimization works transparently to cache the results of eligible T-SQL queries. When the same query is issued again, it directly retrieves the stored result, instead of recompiling and recomputing the original query. This operation drastically … Continue reading “Result Set Caching for Microsoft Fabric Data Warehouse (Preview)”