Summary

In this chapter, you examined the Synapse Analytics database relational storage option. You learned about the MPP architecture and the control and compute nodes, as well as how tables can be distributed or replicated in a database and how partitioning influences the data in the database.

You read about the CCI and how you can benefit from its performance.

Furthermore, you learned about resource allocation, concurrency, and the limits of the DWUc configurations. We touched on workload management and how you can optimize your database workload before you need to scale the database and pay more money for it. But when you need to scale for more concurrency and memory, and therefore more performance, you now know where to search for this functionality.

At the end, you covered the basics of loading data and why it is a good idea to use the COPY statement. You then learned how to maintain your statistics and how to rebuild your CCI to optimize it.

Finally, we compared...