For each table reference in the query, query Tuner adds the following annotations.
对于查询中的每个表引用,QueryTuner会添加以下注释。
The ACCESS element must be used when the target table reference is a derived table.
当目标表引用是一个派生表时,那么必须使用ACCESS元素。
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。
You can now reference the nickname in your application as if it were a local table.
你现在可以在你的应用程序中引用这个昵称,就像它是一个本地表一样。
Use Table 2 as a handy reference for octal permissions.
使用表2作为一个方便的八进制权限参考。
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.
例如对表格来说,能够使用特定的分离级别在数据源中定义一个资源应用,同时使用不同的分离级别在相同数据库中定义另一个引用。
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.
这个页面中定义的模式使用变量,比如表名和列名,而不引用词汇。
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、值对象类、数据行的会话属性和组合框(如果有的话)的会话属性的引用。
Fill in the information using Table 2 as a reference.
使用表2作为参考,填充信息。
For quick reference, table 1 lists the labels used on the charts in this article.
为了便于参考,表1列出了本文中图表所用的标签。
Code values are likely to exist in a reference table.
代码值很可能在一个引用表中。
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模式中。
The earlier three data points are included in the table for easy reference.
表中包含了早期的三个数据点便于参考。
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 description of the classes contained in the message queue framework reference implementation package is shown in Table 4.
表4显示消息队列框架引用实现包中所包含的类的描述。
Quick reference table for all provided PAM service modules are.
所提供的全部PAM服务模块的快速参考表。
The Domain and Completeness screen allows you to make specific decisions around the completeness and validity of the values, whether by specific value, by range, or via a reference table.
通过DomainandCompleteness屏幕,可以根据特定的值、范围或通过一个引用表做出关于值的完整性和有效性的决定。
The Domain and Completeness screen allows you to make specific decisions around the completeness and validity of the values, whether by specific value, by range, or via a reference table.
通过DomainandCompleteness屏幕,可以根据特定的值、范围或通过一个引用表做出关于值的完整性和有效性的决定。
应用推荐