Anteckning
Åtkomst till den här sidan kräver auktorisering. Du kan prova att logga in eller ändra kataloger.
Åtkomst till den här sidan kräver auktorisering. Du kan prova att ändra kataloger.
Applies to: 
Azure Synapse Analytics
Displays distribution information for columns in a materialized view.
| Column Name | Data Type | Description |
|---|---|---|
| object_id | int | ID of the object to which the column belongs. |
| column_id | int | The ID of the column. |
| distribution_ordinal | tinyint | 0 = Not a distribution column. 1 = Azure Synapse Analytics is using this column to distribute the materialized view. |
Permissions
Requires VIEW DATABASE STATE permission.
See also
Performance tuning with Materialized View
CREATE MATERIALIZED VIEW AS SELECT (Transact-SQL)
ALTER MATERIALIZED VIEW (Transact-SQL)
EXPLAIN (Transact-SQL)
sys.pdw_materialized_view_distribution_properties (Transact-SQL)
sys.pdw_materialized_view_mappings (Transact-SQL)
DBCC PDW_SHOWMATERIALIZEDVIEWOVERHEAD (Transact-SQL)
Azure Synapse Analytics and Parallel Data Warehouse Catalog Views
System views supported in Azure Synapse Analytics
T-SQL statements supported in Azure Synapse Analytics