Star join supports snowflake schema as well.
星型连接也支持雪花模式。
The optimizer can choose a star join plan only if a query involves tables from a star or snowflake schema that meets the following requirements.
只有查询中包含满足以下要求的星型或雪花模式的表时,优化器才可以选择星型连接计划。
When you define a dimension based on a snowflake schema, which is where dimension attributes are derived from multiple related tables, an attribute relationship is automatically defined as follows.
当您基于雪花型架构(在该架构中,维度属性派生自多个相关的表)定义维度时,会按如下方式自动定义属性关系。
应用推荐