The entire fact table is read if all dimension table joins are removed by this optimization.
如果所有的维度表连接被该优化移除，则会读取全部事实表记录。
Having fined-grained database tables means more table joins and accordingly more complex queries.
细粒度的数据表意味着更多数据表连接，相应的查询也会更复杂。
Writing SQL queries that use these more advanced table joins will be addressed in future articles.
编写使用这些比较高级的表连接的SQL查询将在后续文章中介绍。
Which two statements are true regarding the USING and ON clauses in table joins? (Choose two.)
关于表连接的USING和ON子句，哪两句话是正确的？(选择两个)。
Furthermore, querying decomposed XML data can be challenging, often requiring multi-table joins.
另外，查询分解的XML数据很困难，常常需要多表联结。
Learn about relational databases, data models, unique keys, primary keys, foreign keys, and table joins.
了解关系数据库、数据模型、惟一键、主键、外键和表联结。
This is a particular case when one table joins to itself with one or two aliases to avoid confusion.
一个表联接自己时是一种特殊情况，为了避免混淆，采用一个或两个别名。
Design sane query schemas. don't be afraid of table joins, often they are faster than denormalization.
设计健全的查询模式。不要害怕表联合，通常它们比非范式化更快。
This implicit association avoids database table joins and extra selections, and cuts down data transfer size.
这种隐式关联避免了数据库表连接和额外的字段选择，降低了数据传输的大小。
Relational queries, such as table joins, are possible, but they are implemented by multiple sequential queries.
关系查询（例如表连接）是允许的，但要通过多个连续查询才能实现。
In the absence of table joins, de-normalization is often used in HBase to keep related information in one table.
在缺乏表连接时，HBase通常使用去规范化(de - normalization)来将相关信息保存在一个表中。
As shown above, queries on concrete classes only select the required data without unnecessary table joins or unions.
正如上文所示，对具体类的查询只选择需要的数据，没有不必要的表连接和联合。
Also, some data source types (such as XML files) do not support parameters, so table joins might be the next-best option.
同样，有一些数据源类型(例如XML文件)并不支持参数，所以表格可能是最好的选项了。
The approach generally fits well with a data warehouse system since all data is in one table without the need for table joins.
这种方法通常比较适合数据仓库系统，因为所有数据都在一张表里，不需要做表连接。
Is the duplication of data in multiple tables of frequently requested columns, more or less expensive than performing the table joins?
对于具有经常被请求的列的多个表，一种是复制其中的数据，一种是执行表连接，两者谁的成本更高呢？
The reason: Normalization requires more tables, table joins, keys and indexes and thus more internal database operations for implement queries.
其原因是：规范化需要更多的表，连接等操作，主键、索引，从而需要更多的内部操作。
This section focuses on selecting data from a single table; the last section in this article covers table joins and selecting data from multiple tables.
这一节将重点介绍如何从单表中选择数据；本文中的最后一节将介绍表连接和如何从多个表中进行选择。
This option, however, still retrieves the dimension members on the edges through joins to a common fact table.
但此选项，仍然会在边上通过连接到普通事实表来检索维度成员。
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 fake fact table will be used in the joins instead of the actual fact table, thereby improving response times when querying solely from the dimensions.
伪事实表将会用在连接中代替实际的事实表，从而提升单独从维度查询的响应时间。
This dynamic filter on the fact table reduces the number of rows used in the probe phase of the actual hash joins.
事实表上的动态过滤减少了实际散列连接探测阶段使用的行数。
Examples of operations that use the sort heap include hash joins and operations where the table is in memory.
使用排序堆的操作示例包括内存中表的散列连接和操作。
You would probably need to set up a many-to-many relationship with a join table, requiring several joins to determine the actors for a particular movie.
您可能需要使用一个联接表设置一个多对多关系，这需要几个联接来确定某个电影的演员。
It pulls person instances from the instances table in the EIDB, and through joins with other tables finds the documents in which the person instances are mentioned.
它从EIDB中的instances表中取出人实例，并通过与其他表进行联结，寻找提到这个人实例的文档。
However, the benefit of the merge scan join is that the inner table does not have to be scanned repeatedly as it does for nested loop joins.
然而，合并扫描联接的好处是不必反复地扫描内部表因为其为嵌套循环联接工作。
Table and use an AS clause to name these columns for the display with the ij tool. Because the query joins these two tables (by using an implicit inner join), you can select columns from both tables.
因为查询(通过使用隐式内连接)将两个表连接，您可以从两个表中选择列。
To illustrate hybrid relational and XML queries as well as joins, we also have a pure relational table unit which lists the name, manager, and so on, for each unit.
为阐明混合关系型查询、XML 查询和连接，我们还提供了一个纯粹的关系型表 ——unit，其中列出了各单位的名称、主管等信息。
When lookup tables are used in joins with other large partitioned table spaces, you can maximize the parallelism in the join by partitioning the lookup tables as well.
当将查找（lookup）表与其他较大的分区的表相连接时，通过将查找表也进行分区，可以最大化并行度。
Data may seem to disappear at this point since the joins through the fact table is likely more sparse in its combinations than the Cartesian Product results.
此刻数据好像消失了，因为事实表的连接似乎比笛卡尔product结果更加稀少。
For example, using the sample data in Figure 1, the following index idx1 would be useful for look-ups and joins based on author IDs across all documents in the XML column bookinfo of the table books.
例如，使用图1中的示例数据，可以根据author id使用下面的索引idx 1对表books的xml列bookinfo中的所有文档进行查找和连接。
应用推荐