sys.pdw_materialized_view_column_distribution_properties (Transact-SQL)
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