| title | description | author | ms.author | ms.date | ms.service | ms.subservice | ms.topic | dev_langs | monikerRange | |
|---|---|---|---|---|---|---|---|---|---|---|
sys.pdw_materialized_view_distribution_properties (Transact-SQL) |
sys.pdw_materialized_view_distribution_properties (Transact-SQL) (preview) |
XiaoyuMSFT |
xiaoyul |
07/03/2019 |
sql |
data-warehouse |
reference |
|
=azure-sqldw-latest |
[!INCLUDE asa]
Displays distribution information materialized views.
| Column Name | Data Type | Description |
|---|---|---|
| object_id | int | ID of the materialized view for which thee properties were specified. |
| distribution_policy | tinyint | 2 = HASH 4 = ROUND_ROBIN |
| distribution_policy_desc | nvarchar(60) | HASH, ROUND_ROBIN |
Requires VIEW DATABASE STATE permission.
CREATE MATERIALIZED VIEW AS SELECT (Transact-SQL)
ALTER MATERIALIZED VIEW (Transact-SQL)
EXPLAIN (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