介绍星型连接计划的解释输出。
星型连接也支持雪花模式。
促进或阻止星型连接优化。
为进行星型连接优化引入了新的优化器指令。
New optimizer directives are introduced for star join optimization.
模式不需要明确指定一列是主键或唯一键来产生星型连接计划。
The schema does not need to specify explicitly that a column is a primary or unique key to produce a star join plan.
所有新的星型连接指令都是查询层次的指令，会影响查询的执行。
All the new star join directives are query level directives that affect the execution of a query.
提出了一种复值函数型连接神经网络(CFLNN)结构及其学习算法。
A Complex-valued Functional Link Neural Network (CFLNN) with its training algorithm is proposed.
当使用“强制”选项时，当前会话的所有查询只要可能就使用星型连接计划。
When the "forced" option is used, star join plans will be favored whenever possible for all queries in current session.
FACT (table)—FACT指令指定在星型连接优化中使用的事实表。
Fact (table) - The fact directive specifies a fact table to be used during star join optimization.
在设计的双层光互连网络中，上层网络是星型连接，依靠数字路由结点进行通信。
A two-layer parallel optical interconnection network has been designed. The top layer was a star network, which was made up of digital routing nod, node computer and optical network interface CARDS.
只有查询中包含满足以下要求的星型或雪花模式的表时，优化器才可以选择星型连接计划。
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.
该网络把级数中的函数看成非线性神经元，建立油藏系统的函数型连接人工神经网络模型。
In the net, the functions are served as nonlinear neural units to establish function link artificial neural networks models of oil reservoir systems.
目前大部分厂商采用角型连接电容器串接14.5%电抗器滤除3次谐波，其实作用甚微。
At present most of manufacturers filter 3rd harmonic by using Angle glaucoma connection capacitor to connect 14.5 reactance, in fact there is only slight effect.
我们使用前面的同一个示例查询来说明如何解释星型连接计划的SETEXPLAIN输出。
To show how to interpret SET EXPLAIN output for star join plans, we use the same example query as before.
一个星型连接查询通常包含一个事实表和几个维度表，事实表和每个维度表之间都有连接谓词。
A star join query typically involves a fact table and several dimension tables, with join predicates between the fact table and each dimension table.
星型连接计划中，数据库服务器在维度表中构建散列表的同时从维度表中下推键来过滤事实表。
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.
新的优化器指令和会话环境控制因为影响优化器对星型连接优化的考虑，所以文中也包含了它们的介绍。
New optimizer directives and session environment controls are also introduced for influencing optimizer consideration of star join optimization.
不选用双绞线，是极端过错的。485总线一定要是手牵手式的总线结构，坚决根绝星型连接和分叉连接。
Do not use twisted pair, is extremely wrong. 485 bus must be hand in hand type bus structure, resolutely eradicate star connection and branch connection.
利用下推连接技术的星型连接计划使得散列连接更加有效的主要原因是，在初期减少了事实表(探测表)的行数。
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.
为了实现星型连接查询的最佳执行计划，优化器在适当的时候会考虑星型连接优化，并根据成本因素来决定星型连接计划。
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.
也引入了新的SETOPTIMIZATIONENVIRONMENT选项，用于影响优化器对星型连接计划的考虑。
New SET OPTIMIZATION ENVIRONMENT options are also introduced for influencing optimizer consideration of star join plans.
在您看到星型连接优化的优点后，本文通过带有注释的解释输出准确地告诉您星型连接计划的信息是如何出现在解释文件中的。
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.
本文介绍的所有新的XML访问准则可能会被嵌入到这些关系型连接准则中，从而指定连接的innerleg或outer leg。
All the new XML access guidelines introduced in this article may be nested within these relational join guidelines to specify the inner or outer leg of the join.
SETOPTIMIZATION ENVIRONMENT star_join语句可用来启用、禁用或强制星型连接计划用于当前会话的所有查询。
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.
SETOPTIMIZATIONENVIRONMENTFACT语句针对当前会话的所有查询，用于指定一个在星型连接优化中可被视为事实表的表清单。
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.
与匀质型的体系结构相反，在分层型或分片型体系结构中，玩家连接到一个服务器层。
In contrast to the homogeneous-type architecture, players within the tiered - or shard-type architecture connect to a layer of servers.
过了德比就到了贝尔峡谷，路上的树丛越来越茂密。到了路的尽头，在赭石色山崖的阴影中横贯着阶梯型的黑色池塘，池塘之间由跌落的瀑布相连接。
Beyond Derby, at Bell Gorge, tiered pools of dark water, Shadowed by ochre cliffs and connected by a tumbling cascade, lay at the end of an increasingly verdant bush walk.
其结果就是一款名为肺量测定法侦察员的吸入器问世，这款吸入器带有内置的全球定位系统定位和(高级型)联到互联网的无线连接。
The result is Spiroscout, an inhaler with a built-in Global Positioning System locator and (in advanced models) a wireless link to the Internet.
创建一个新的，连接型的网络。
创建一个新的，连接型的网络。
应用推荐