From the course: Microsoft Azure Synapse for Developers

Unlock this course with a free trial

Join today to access over 25,600 courses taught by industry experts.

Analyzing data distribution

Analyzing data distribution

From the course: Microsoft Azure Synapse for Developers

Start my 1-month free trial Buy for my team

Analyzing data distribution

“

- [Instructor] In this demo, we are going to talk about distribution and how to verify that the data is distributed properly. To view how the data is distributed for a table, since each table is distributed throughout 60 distributions, we can use the following command: SHOWSPACEUSED, and then we specify the table name. If we run it, then we should get data about our distributions. Let's go ahead and explore it. We have ROWS, so how many rows are in each distribution. And it looks like our distribution is pretty even. We have RESERVED_SPACE, DATA_SPACE, INDEX_SPACE, UNUSED_SPACE, and the DISTRIBUTION_ID. So we have one, and then we should have up to 60. What we are interested in is ROWS as that's what we are going to do to JOINs and WHERE clauses, et cetera. So the number of rows should be very close to each other in order for optimal query performance. Now, this is not very easy to view, so let's go ahead and move to the…

Contents