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
Feedback
https://aka.ms/ContentUserFeedback.
În curând: Pe parcursul anului 2024, vom elimina treptat Probleme legate de GitHub ca mecanism de feedback pentru conținut și îl vom înlocui cu un nou sistem de feedback. Pentru mai multe informații, consultați:Trimiteți și vizualizați feedback pentru