As a database developer, you usually join the customer table to the contact table and treat the customer as the main table.
作为数据库开发人员,您通常将客户表与联系方式表连接,并将客户表视作主表。
Query Q3 (5predsome) has multiple predicates and USES three side tables plus the main table, so it needs to compute a four-way join.
查询Q3 (5predsome)具有多个谓词、使用3个索引表和主表,因此它需要计算一个4路结合。
With side tables, DB2 first performs an index lookup on the side table and then joins the corresponding row with the main table that contains the CLOBs.
在使用索引表的情况下,DB 2首先对索引表执行索引查找,然后将对应的行和包含CLOB的主表相结合。
The Date, Company and Site fields (from the main table) are important information because statistical information is centred on a date, a company and a site.
日期、公司、地点字段(来自主表)是非常重要的信息,因为统计信息是他们为中心进行检索的。
However, for performance alone, in V8 it's usually better to use load directly into the main table, because load doesn't have the concurrency restrictions it had in V7.
不过,单单就性能而言,在v8中还是使用load直接将表装载到主表要快些,因为在V 8中的load不像v7中那样有并发限制。
So all 7 rows are read (and first locked) from the main table, the value in the data_column is compared to deadlock 1, and the rows that match are passed up into the join.
因此主表中所有7行都被读取(先上锁),data_column 中的值与deadlock1比较,匹配的行参与联接。
Updates made to the main table result in actions that push out the previous values of data to the history tables. This is either done through triggers or by the applications themselves.
在更新主表的时候会把旧数据推入历史表中,这个过程一般是通过触发器或由应用程序自己来完成。
So to find the row that satisfies the predicate in the select statement, the optimizer has to lock, read in, and compare all the rows in the main table with the value supplied in the predicate.
因此要找到满足select语句中谓词的行,这个优化器必须将主表中的所有行上锁、读取它们的值并与谓词中提供的值进行比较。
Now take the main body part and place it head down on the table and lift up the back and place the arms in the middle like so: (a stone is holding down the top part).
现在做身体部分,把它的头向下放在桌子上,抬起背,并把手臂放置在中间位置,就像顶部有一块大石头被压在下面。
By making a view, rather than an explicit table, we avoid the main disadvantage of a vertical schema, namely that many queries require it to be joined with itself, which can be expensive.
通过定义视图而不是显式的表,可以避免垂直模式的主要缺点,即许多查询要求它与本身进行联结,而这种操作是很昂贵的。
A TLB miss requires accessing a page table that is stored in the main memory, which consumes considerably more processor cycles.
如果TLB没有命中,那么就需要访问存储在主存中的页表,而这样做需要消耗相当多的处理器周期。
There are two major forms of schistosomiasis – intestinal and urogenital – caused by five main species of blood fluke (see table).
血吸虫病主要分两种,一是肠血吸虫病,二是尿路血吸虫病。 血吸虫主要有五种(见附表)。
The main reason the tandem held together for more than a couple of years was that each of the entrepreneurs brought something valuable to the table.
这个双头组合维持超过数年时间的主要原因在于:两位企业家各自都提供了有价值的东西。
The main loop then looks through its internal mapping table between its signals and handlers, also called callbacks, and calls the handlers registered for the given signal on the given object.
然后主循环查询自己的信号和处理程序之间的内部映射表,也叫做回调,并调用注册到指定对象的指定信号的处理程序。
The main advantage of the XML support in the relational database is that you can save both relational and XML data in the same table.
关系数据库中的XML支持的主要好处是,可以在同一个表中同时存储关系数据和XML数据。
But in recent years, Anta has become the main sponsor for activities such as the Chinese Basketball Association, the China Volleyball league and China's table-tennis league.
但最近几年安踏已成为中国篮球协会、中国排球协会和中国乒乓球协会等举办的体育赛事的主要赞助商。
The food on the table is seasonal, and often the main attraction is hairy crabs, which are at their largest and richest with roe during autumn.
中秋节日餐桌上的食物都是应季的,最受人们喜爱的当属大闸蟹,在秋季时大闸蟹个头最大,蟹黄最为肥美。
The generated COBOL consists of two main programs per DB2 table, along with auxiliary COBOL programs to perform the XML parsing, and so on.
对于每个db2表,所生成的COBOL包括两个主程序和一些辅助COBOL程序(以执行xml解析)等。
Furthermore, compressed pages of a DB2 table space remain compressed in the DB2 buffer pool in main memory.
而且DB 2表空间的压缩页在主内存的db2缓冲池中仍保持压缩。
The main component of Habitat is a 100 square foot cubic pod that is designed to house a bed, a table, a kitchen and a storage space.
这个居所的主要部分是安放床、桌、厨房和储存空间的一个100立方英尺的立方形豆荚。
Table 3 below lists three program examples: a C main program and two COBOL programs.
下面的表3列出了三个程序例子:一个c语言编译的主程序和两个COBOL程序。
Put simply, we need tougher negotiators on our side of the table-to strike bargains that are good not just for Wall Street, but also for Main Street.
简言之,我们需要谈判桌上有更为强硬的谈判专家—达成既有利于华尔街又有利于普通商业街的协议。
The main room is empty, save for a square wooden dining table with four narrow benches.
客厅是空的,仅有一张吃饭用的方木桌和四张窄凳。
Table 1 shows the main taxonomy of WAI-ARIA contents.
表1显示了WAI - ARIA内容的主要分类。
The main goal of agile planning is having as much of the "known" work as possible on the table and visible to all.
敏捷规划的首要目标是最大程度地明确“已知”工作并且完全公开它们。
The main characteristics as well as selected pros and cons of each strategy are listed in table 1.
表1列出每种战略的主要特征以及优缺点。
Line 32 USES the "XSL: for-each" element to define the loop that creates the main part of the table, generating one line for each "emp" element occurrence.
第32行使用“xsl:for - each”元素来定义创建表的主要部分的循环,用以为每个出现的“emp”元素生成一行。
Line 32 USES the "XSL: for-each" element to define the loop that creates the main part of the table, generating one line for each "emp" element occurrence.
第32行使用“xsl:for - each”元素来定义创建表的主要部分的循环,用以为每个出现的“emp”元素生成一行。
应用推荐