You can define guidelines that influence only a few attributes of an execution plan, such as index specification for a certain table in the query or join order for a pair of tables.
可以定义那些只影响执行计划的某些属性的准则,比如查询中的某个表的索引说明,或者一对表的连接顺序。
For each of these joins, find which side of the join contains attributes from the facts object.
对于每个联结,查明联结的哪一边包含事实对象属性。
The Join object has left-side attributes and right-side attributes, which are compared to each other to form join predicates.
联结对象具有左属性和右属性,对这两个属性进行比较,从而形成联结谓词。
Dealing with the attributes on the other side of the join will be discussed later, when detailing the steps required for the facts object.
对联结的另一边上属性的处理将在后面讨论事实对象所需的步骤时讨论。
Generate the expression for the join predicate by applying the join operator to the expressions for the left and right attributes.
将联结操作符应用于左右属性的表达式,从而产生联结谓词的表达式。
SQL expressions will need to be created from these attributes to form the join predicates of the SQL statement.
需要从这些属性创建SQL表达式,从而形成sql语句的联结谓词。
If the facts object contains any join references, then look at each of these join objects and keep track of all attributes from both the left and right sides of these joins.
如果事实对象包含任何联结引用,那么要查看每个联结对象,记录这些联结左右两边的所有属性。
The attributes on this side will need to be converted to SQL expressions to form the join predicates of the SQL statement.
这一边上的属性需要转换为SQL表达式,从而形成sql语句的联结谓词。
There will be one or more attributes from the facts object referenced by the join object, which is used to join the dimensions of the query to the facts object.
用来将查询的维联结到事实对象的联结对象会引用事实对象的一个或多个属性。
Since TIMEID (SALESFACT) is in sales facts, use the attributes on the left side of the join.
因为TIMEID (SALESFACT)属于sales事实,所以在联结的左边使用这个属性。
Since PRODUCTID (SALESFACT) is in sales facts, use the attributes on the left side of the join.
因为PRODUCTID (SALESFACT)属于sales事实,所以在联结的左边使用这个属性。
Time does not contain any join references, so no attributes are identified in this step.
time不包含任何联结引用,所以在这一步中没有识别出属性。
Since the sales facts contain no join references, no attributes are identified in this step.
因为sales事实不包含联结引用,所以这一步没有识别出属性。
Since attribute TIMEID (time) is in the time dimension, use the attributes on the right side of the join.
因为属性TIMEID (time)属于time维,所以在联结的右边使用这个属性。
Since attribute STOREID (store) is in the store dimension, use the attributes on the right side of the join.
因为属性STOREID (store)属于store维,所以在联结的右边使用这个属性。
Since attribute PRODUCTID (product) is in the product dimension, use the attributes on the right side of the join.
因为属性PRODUCTID (product)属于product维,所以在联结的右边使用这个属性。
If Di contains any join references, then look at each of these join objects and keep track of all attributes from both the left and right sides of these joins.
如果Di包含任何联结引用,那么要查看每个联结对象,记录这些联结左右两边的所有属性。
There will be one or more attributes from Di, which are referenced by the join object, which is used to join Di to the facts object.
用来将Di联结到事实对象的联结对象会引用 Di 的一个或多个属性。
To find which side of the join Di is supposed to be on, look at the attributes for both the left and right sides of the join to see which side contains attributes for Di.
要想了解Di在联结的哪一边,可以查看联结左右的属性,看哪一边包含Di的属性。
A join transform combines the values of two or more source attributes and copies them to a target attribute.
联接转换组合两个或更多个源属性的值,并将它们复制到一个目标属性。
Attributes from any join references in the facts object.
来自事实对象中任何联结引用的属性。
How to create an association that sets join table attributes automatically?
如何创造一套联接表的属性自动关联吗?
"These batteries have many of the same attributes as thin-film batteries, but can be packaged in large formats," says Roland Pitts, a senior scientist at NREL who has agreed to join the company.
“这些电池的许多特性同薄膜电池相当,但可以组成大号的电池,”国家可再生能源实验室的资深科学家罗兰·皮茨说道。
The competition of publishing industry has become fiercer, therefore it requires more project editors to join in, who must have the integrated attributes.
出版行业竞争越来越激烈,需要更多的有综合素质的策划编辑。
The competition of publishing industry has become fiercer, therefore it requires more project editors to join in, who must have the integrated attributes.
出版行业竞争越来越激烈,需要更多的有综合素质的策划编辑。
应用推荐