sys.pdw_materialized_view_column_distribution_properties (Transact-SQL)

Applies to: yesAzure 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