Learn more in Partitioning tables in dedicated SQL pool. Table partitioning is also available in dedicated SQL pools in Azure Synapse Analytics, with some syntax differences. Partitioned tables and indexes are available in all service tiers of Azure SQL Database and Azure SQL Managed Instance. For a list of features supported by the editions of SQL Server, see Editions and Supported Features for SQL Server 2016. Prior to SQL Server 2016 (13.x) SP1, partitioned tables and indexes were not available in every edition of SQL Server. The table or index is treated as a single logical entity when queries or updates are performed on the data. All partitions of a single index or table must reside in the same database. The data is partitioned horizontally, so that groups of rows are mapped into individual partitions. When multiple files exist in a filegroup, data is spread across files using the proportional fill algorithm. The data of partitioned tables and indexes is divided into units that may be spread across more than one filegroup in a database or stored in a single filegroup.
SQL Server, Azure SQL Database, and Azure SQL Managed Instance support table and index partitioning.
0 kommentar(er)
