Implementing different table geometries with Azure Synapse Analytics pools
The term table geometry is not standard database terminology, so I'm taking an educated guess that the certification team meant the different features of Azure Synapse dedicated pool tables.
The main features of Synapse dedicated pool tables are partitions, indexes, and distributions. We have already covered partitions and distributions in detail, so we will focus on the remaining feature, which is indexing.
SQL dedicated pools provide the following three types of indexing:
- Clustered columnstore indexing
- Heap indexing
- Clustered indexing
Let's look at them in detail.
Clustered columnstore indexing
Clustered columnstore is the default indexing option of a dedicated SQL pool table. This type of indexing works best for large fact tables. It is a column-based data storage and provides very high levels of compression and better query performance than row-based indexes.
...
