Data Engineering notes

Statistics strategy for external tables in Synapse Serverless SQL pool

What exactly is a SQL statistic? Before we dive into the details on Synapse Serverless SQL, let’s quickly cover what a SQL statistic actually is. Simply put, it is a small object inside the database that contains information about how the data is distributed in a specific column. It helps the database engine understand what the data looks like without having to scan the entire table first.

Read more →

March 27, 2026