For each table reference in the query, query Tuner adds the following annotations.
对于查询中的每个表引用,QueryTuner会添加以下注释。
Predicates are reordered and regrouped based on the kind of predicate (local or join) and the table reference.
重新排序和重新组合谓词是基于谓词的种类(本地或联接)和表引用。
Another potential problem is the local predicate on the table reference CUST_ORDER_HEADER (COHE) in the inner sub-query (see also in Figure 9).
另一个潜在问题是内部子查询中CUST_ORDER_HEADER (COHE)表引用上的本地谓词(见图9)。
That is, each probe into the second table reference and the third table reference would efficiently locate the only record that matches the join condition.
也就是说,进入第二个表引用和第三个表引用的探测只将有效地定位匹配联接条件的记录。
To the right of each table reference is the table cardinality (in terms of both number of records and number of pages) and the estimated number of qualified rows.
每个表引用的右边是表基数(依据记录的数量和页面的数量)以及合格行的估计数量。
The number associated with QUALIFIED_ROWS represents the estimated number of records that would qualify all the local predicates of the underlying table reference.
与 QUALIFIED_ROWS相关的数代表将使基础表引用的所有本地谓词合格的估计的记录数量。
According to the annotation information in the figure, the table reference CUST_CUSTOMER (CCUS) has two local predicates which are very selective, with filter factor 0.00727 and 0.004, respectively.
根据图中的注释信息,优先表CUST_CUSTOMER (CCUS)有两个本地谓词,其选择性很强,各自的过滤因子分别是0.00727和0.004。
For example, I can define one resource reference to a data source with a specific isolation level for a table, while defining another reference to the same database with a different isolation level.
例如对表格来说,能够使用特定的分离级别在数据源中定义一个资源应用,同时使用不同的分离级别在相同数据库中定义另一个引用。
The database in this example contains only one table to store the test sequence, because the conversion reference information is embedded in the PHP script.
本例中的数据库只包含一个表来存储测试序列,因为转换引用信息被嵌入到php脚本中。
For row change timestamp columns only, if the column is defined with the IMPLICITLY HIDDEN attribute, then it is not externalized when there is an implicit reference to the columns of the table.
对于行修改时间戳列(只针对这种列),如果该列使用IMPLICITLYhidden属性定义,那么当对表列进行隐式引用时,不会对该列执行外部化。
Table 2 shows a partial list, for illustration purposes, of reference materials on patterns and how they map to each SOA scenario.
表2出于演示目的显示了列表的一部分,该列表列出了关于模式的参考资料和它们是如何映射到每个SOA场景的。
You need to define a partner reference in a rule group when a rule set or a decision table invokes another component.
当规则集或决策表调用另一个组件时,您需要在规则组中定义伙伴引用。
We'll discuss other variables as we go along, and there is also a reference table at the end of this article that lists all template variables and gives examples of USES for them.
随后我们还将会探讨其他的变量,在文章的结尾由一个引用表,它列出了所有的模板变量,并给出了使用它们的范例。
The database server automatically issues the prepare statement to update any prepared objects that reference the table.
数据库服务器自动发出PREPARE命令,更新引用该表的任何编译过的对象。
You can reference a created temporary table in SQL functions, triggers, indexes, and views.
您可以在sql函数、触发器、索引和视图中引用已创建的临时表。
It's quite typical for firms to store both relational and XML data in a single table, and our examples reference both types of columns.
公司在单个表中既存储关系数据也存储XML数据是很常见的情况,我们的示例引用了这两种类型的列。
If a column reference is found, then include the column's table to the fact's set of tables.
如果找到列引用,那么将这个列所在的表包含到事实的表集中。
The patterns defined in this page use variables, such as table name and column name, and don't reference terms.
这个页面中定义的模式使用变量,比如表名和列名,而不引用词汇。
You can now reference the nickname in your application as if it were a local table, and they will appear to clients as DB2 tables.
您现在可以在应用程序中引用昵称,就像它是本地表一样,它们将对客户端显示为db2表。
How can P2 and P3 reference a temporary table declared in P1 without re-declaring it themselves?
P2和P3又如何能引用P 1中声明的临时表而无需再重新声明呢?
Obtains the reference for the table ID, value object class, session attribute for data rows, and session attribute for combo box if one exists.
取得对表格ID、值对象类、数据行的会话属性和组合框(如果有的话)的会话属性的引用。
Anything from table cells to form fields to links, you can uniquely reference and modify client side through both their attributes and CSS properties.
从表的单元格到表单字段再到链接,您都能通过其特征和css属性惟一地引用和修改。
For quick reference, table 1 lists the labels used on the charts in this article.
为了便于参考,表1列出了本文中图表所用的标签。
In most cases, well-suited SQL statements are very simple SELECT statements that reference only a single table or are INSERT, UPDATE, and DELETE (UID) operations that are executed many times.
在大多数情况下,非常适合使用参数标记的sql语句要么是非常简单的SELECT语句(只引用一个表),要么是被多次执行的INSERT、UPDATE和DELETE (uid)操作。
If a reference to a table is not qualified in the DAD, it will be assumed to reside in the specified default SQL schema.
如果表的一个引用不是限定在DAD中,就会被假定在指定的默认SQL模式中。
In addition, you can use the field Table view to create fields from a database reference file on a connected system.
另外,您可以使用FieldTable视图来从链接系统上的数据库引用文件中创建区域。
Most portability issues can be divided into five classes based on the system resources they access or reference, as listed in Table 1.
多数可移植性问题根据他们访问的或引用的系统资源可以被分成5类,见表1。
The VALUES clause also includes a casting function for the user-specified value of the OID column because the value must be cast into the REFERENCE type of the target table.
values子句还为用户指定的oid列的值包括了一个casting函数,因为该值必须强制转换成目标表的REFERENCE类型。
The description of the classes contained in the message queue framework reference implementation package is shown in Table 4.
表4显示消息队列框架引用实现包中所包含的类的描述。
Listing 9 makes the reference to the deployed PetsDB connector and specifies the exact table and field mapping.
清单9给出了对部署的PetsDB连接器的引用,并指定了将要映射的表和字段。
应用推荐