Star join supports snowflake schema as well.
星型连接也支持雪花模式。
Interpreting explain output for star join plans.
介绍星型连接计划的解释输出。
Encouraging or preventing star join optimization.
促进或阻止星型连接优化。
New optimizer directives are introduced for star join optimization.
为进行星型连接优化引入了新的优化器指令。
All the new star join directives are query level directives that affect the execution of a query.
所有新的星型连接指令都是查询层次的指令，会影响查询的执行。
Fact (table) - The fact directive specifies a fact table to be used during star join optimization.
FACT (table)—FACT指令指定在星型连接优化中使用的事实表。
In this case, the first column of any index, simple or compound, is a candidate to satisfy the star join.
在这种情况下，任何索引的第一行，不管简单或复杂，都是满足星型联接的一个候选者。
To show how to interpret SET EXPLAIN output for star join plans, we use the same example query as before.
我们使用前面的同一个示例查询来说明如何解释星型连接计划的SETEXPLAIN输出。
When the "forced" option is used, star join plans will be favored whenever possible for all queries in current session.
当使用“强制”选项时，当前会话的所有查询只要可能就使用星型连接计划。
The schema does not need to specify explicitly that a column is a primary or unique key to produce a star join plan.
模式不需要明确指定一列是主键或唯一键来产生星型连接计划。
New SET OPTIMIZATION ENVIRONMENT options are also introduced for influencing optimizer consideration of star join plans.
也引入了新的SETOPTIMIZATIONENVIRONMENT选项，用于影响优化器对星型连接计划的考虑。
New optimizer directives and session environment controls are also introduced for influencing optimizer consideration of star join optimization.
新的优化器指令和会话环境控制因为影响优化器对星型连接优化的考虑，所以文中也包含了它们的介绍。
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.
只有查询中包含满足以下要求的星型或雪花模式的表时，优化器才可以选择星型连接计划。
A star join query typically involves a fact table and several dimension tables, with join predicates between the fact table and each dimension table.
一个星型连接查询通常包含一个事实表和几个维度表，事实表和每个维度表之间都有连接谓词。
The SET OPTIMIZATION ENVIRONMENT STAR_JOIN statement can be used to enable, disable, or force star join plans for all queries in the current session.
SETOPTIMIZATION ENVIRONMENT star_join语句可用来启用、禁用或强制星型连接计划用于当前会话的所有查询。
A star join plan utilizing push-down hash join technology makes hash joins more effective primarily due to reduction of fact table (probe table) rows early on.
利用下推连接技术的星型连接计划使得散列连接更加有效的主要原因是，在初期减少了事实表(探测表)的行数。
In a star join plan, the database server pushes down keys from a dimension table to filter the fact table at the same time as it builds the hash table on the dimension table.
星型连接计划中，数据库服务器在维度表中构建散列表的同时从维度表中下推键来过滤事实表。
After you see the advantages of star join optimization, this article provides annotated explain output to show you precisely how star join plan information appears in explain file.
在您看到星型连接优化的优点后，本文通过带有注释的解释输出准确地告诉您星型连接计划的信息是如何出现在解释文件中的。
The optimizer considers star join optimization when appropriate and decides on star join plan based on cost considerations in order to come up with best execution plan for a star join query.
为了实现星型连接查询的最佳执行计划，优化器在适当的时候会考虑星型连接优化，并根据成本因素来决定星型连接计划。
The SET OPTIMIZATION ENVIRONMENT FACT statement can be used to specify a list of tables that can be considered as fact tables during star join optimization for all queries in the current session.
SETOPTIMIZATIONENVIRONMENTFACT语句针对当前会话的所有查询，用于指定一个在星型连接优化中可被视为事实表的表清单。
What’s more, Aragon was invited to join Gaga on her “Monster Ball” tour last month. She performed a duet with Gaga during the concert, and then made more headlines by making the emotional star cry.
而且，阿拉贡在上个月被邀请参加Gaga的“怪物舞会”巡回演唱会，两人还一同登台演唱，阿拉贡激动的痛哭更是制造了更多的新闻。
What's more, Aragon was invited to join Gaga on her "Monster Ball" tour last month. She performed a duet with Gaga during the concert, and then made more headlines by making the emotional star cry.
而且，阿拉贡在上个月被邀请参加Gaga的“怪物舞会”巡回演唱会，两人还一同登台演唱，阿拉贡激动的痛哭更是制造了更多的新闻。
Head coach Lang Ping Wednesday signed a handful of aces in Guangzhou to join the Guangdong Hengda Women's Volleyball Team. The star lineup includes Feng Kun, Zhou Suhong and Yang Hao.
11日，郎平率领的恒大女排启航仪式在广州举行，由冯坤、周苏红、杨昊等明星球员组成的豪华阵容悉数亮相。
The cube model can be seen as an abstraction of a star-join or snowflake-join schema.
多维数据集模型可以看作星形联结或雪花形联结模式的抽象。
Columns in the join clauses in fact table of star schema database.
星型数据库的事实表中join子句中的列。
The rising star will join seven other satellites already in orbit to form a network which will eventually provide navigation and positioning services around the globe.
该上升卫星将跟另外7颗在轨道运行的卫星一起形成全球定位导航服务系统。
Believe in yourself. Yes! You can. You are the star that we are looking for, join us, and shine as the brightest. Radisson Blu will shine with you.
你要相信自己，你就是我们在寻找的星星，加入我们，努力成为最闪亮的那一颗！在你的加入和共同努力之下，丽笙与你将共同发出无限的光芒。
Arsenal star Jack Wilshere has suggested to Liverpool winger Ryan Babel that he join him at the Emirates Stadium.
阿森纳球星杰克·威尔希尔曾建议利物浦边锋巴贝尔，他参加了他在酋长球场。
Brianna:... to FOX in 2011. Reports say he even approached a certain former co-star to join him.
布兰娜：……将于2011年登陆福克斯电视台。报道称他还将邀请他的前搭档参与其中。
Brianna:... to FOX in 2011. Reports say he even approached a certain former co-star to join him.
布兰娜：……将于2011年登陆福克斯电视台。报道称他还将邀请他的前搭档参与其中。
应用推荐