sys.pdw_materialized_view_column_distribution_properties (Transact-SQL)sys.pdw_materialized_view_column_distribution_properties (Transact-SQL)

S’applique à :Applies to: ouiAzure Synapse AnalyticsAzure Synapse AnalyticsyesAzure Synapse AnalyticsAzure Synapse AnalyticsS’applique à :Applies to: ouiAzure Synapse AnalyticsAzure Synapse AnalyticsyesAzure Synapse AnalyticsAzure Synapse Analytics

Affiche des informations de distribution pour les colonnes d’une vue matérialisée.Displays distribution information for columns in a materialized view.

Nom de la colonneColumn Name Type de donnéesData Type DescriptionDescription
object_idobject_id intint ID de l’objet auquel la colonne appartient.ID of the object to which the column belongs.
column_idcolumn_id intint ID de la colonne.The ID of the column.
distribution_ordinaldistribution_ordinal tinyinttinyint 0 = n’est pas une colonne de distribution.0 = Not a distribution column.
1 = Azure Synapse Analytics utilise cette colonne pour distribuer la vue matérialisée.1 = Azure Synapse Analytics is using this column to distribute the materialized view.

AutorisationsPermissions

Requiert l'autorisation VIEW DATABASE STATE.Requires VIEW DATABASE STATE permission.

Voir aussiSee also

Réglage des performances avec une vue matérialisée Performance tuning with Materialized View
CREATE MATERIALIZED VIEW AS SELECT (Transact-SQL) CREATE MATERIALIZED VIEW AS SELECT (Transact-SQL)
ALTER MATERIALIZED VIEW (Transact-SQL) ALTER MATERIALIZED VIEW (Transact-SQL)
EXPLAIN (Transact-SQL) EXPLAIN (Transact-SQL)
sys.pdw_materialized_view_distribution_properties (Transact-SQL) sys.pdw_materialized_view_distribution_properties (Transact-SQL)
sys.pdw_materialized_view_mappings (Transact-SQL) sys.pdw_materialized_view_mappings (Transact-SQL)
DBCC PDW_SHOWMATERIALIZEDVIEWOVERHEAD (Transact-SQL) DBCC PDW_SHOWMATERIALIZEDVIEWOVERHEAD (Transact-SQL)
Vues de catalogue Azure Synapse Analytics et Parallel Data Warehouse Azure Synapse Analytics and Parallel Data Warehouse Catalog Views
Vues système prises en charge dans Azure Synapse Analytics System views supported in Azure Synapse Analytics
Instructions T-SQL prises en charge dans Azure Synapse AnalyticsT-SQL statements supported in Azure Synapse Analytics