Any query that utilizes the Primary Index column will encounter faster response times.
任何利用主索引列的查询将会遭遇更快速响应时间问题。
The operator class also specifies the support procedures to be used by the index method when the operator class is selected for an index column.
操作符表还声明索引方法在为一个索引字段选定该操作符表的时候要使用的支持过程。
Therefore a randomized index column can relieve contention problems for sets of similar or sequential values, but it's no help with identical values.
因此，随机化的列可以减轻一组相似值或序列值的争用问题，但对于相同的值没有帮助。
The maintainability Index column also includes a icon that gives a quick indication as to the overall maintainability and complexity of a particular item.
可维护性指数的列也包括了一个图标，它可以直观的表示出可维护性的总体指数，或是某复杂度很高的部分。
If the database designer has created a Primary partition Index on a table, queries should incorporate the partitioning column.
如果数据库设计者已在表上创建了主分区索引，那么查询应当与分区列结合。
This sounds like a lot of conditions, but so far it is straightforward: using the column, the index can be found and the spatial predicate is known using the function.
这听起来好像有一大堆的条件，但还是比较简单的：通过使用列可以找到索引，通过使用函数可以知道空间谓词。
If there is an index on the join column, the costs will be significantly less; otherwise the database server must perform table scans for all tables, both outer and inner tables.
如果连接列上有一个索引，那么其成本会相当低；否则，数据库服务器就必须对所有表(外部和内部表)执行表扫描。
Information about the column definitions, index, and statistics for a nickname is stored in the DB2 federated database system catalogs.
关于列定义、索引以及昵称统计信息的信息存储在DB 2联邦数据库系统编目中。
Here you must find the index of the column in the position as it appears in the tree.
此处，我们必须在所选列在树中出现的位置找到该列的索引。
For relational nicknames, the wrapper validates the existence of the data source objects and retrieves the column definitions and index information, if any, when the nickname is defined.
对于关系昵称，包装器确认数据源对象是否存在，如果定义了昵称，还将获取列定义和索引信息。
Finally, you can index into the columns by column number and cast the results directly (for some types).
最后，可以根据列编号为这些列建立索引，并直接强制转换结果(对于某些类型)。
For this purpose, an indexed column is any single column with an index or the first column named in a composite index.
为此，索引列是一个包含索引的单列，或者是复合索引中指定的第一个列。
Finally, an index on the additional column is created and the table reorganized based on that index.
最后，在附加列上创建一个索引，并根据那个索引对表进行重组。
Also in the query rewrite vein, modifying a SELECT to get rid of a range-type predicate can increase performance by improving index key column matching.
另外，在查询重写状态下，修改SELECT来摆脱一个范围型谓词，可以通过提高索引键列匹配增强性能。
A functional index transforms the data in a column and stores the derived values in sorted order.
函数索引对列中的数据进行转换并按照顺序保存转换后的值。
The alternative to shredding is to store and index the MIML data in a column of type XML in a DB2 table.
作为分解方法的另一种备选方法是将MIML数据存储在db2表中的xml类型的列中，并为之建立索引。
If you use a nullable VARGRAPHIC column instead, the 1021-byte index limitation is still true.
如果使用可空的vargraphic列，那么1021字节的索引限制仍然是对的。
In this case, the first column of any index, simple or compound, is a candidate to satisfy the star join.
在这种情况下，任何索引的第一行，不管简单或复杂，都是满足星型联接的一个候选者。
While an index on a relational column contains all values from that column, an XML index contains only values of nodes that match both the XML pattern and the data type in the index definition.
关系列上的索引包含了此列的所有值，而xml索引仅包含那些同时匹配XML模式和索引定义中的数据类型的节点值。
As shown in the IXSCAN descriptor in Figure 8, the leading column of the index exploited by optimizer is PRODUCT_NUMBER, which does not provide the order required for merge scan join.
如图8的IXSCAN描述符所示，通过优化器利用的索引的领先列是PRODUCT _ NUMBER，其不为合并扫描联接提供所需的顺序。
To use each variable, you simply use the column number as the index of the single value you want.
要使用每个变量，您只需将列号用作您所需值的索引即可。
The fourth column shows the index type (as defined in the schema in Listing 5) used to represent the datum.
第四列将显示用于表示数据的索引类型(按照清单5的模式中的定义)。
For the purposes of discussion, our chosen index is a three-column index called IX1 created on (COLA, COLB, COLC).
为了便于讨论，我们选择的索引是一个三列索引，名为IX1，在(COLA,COLB,COLC)上创建。
And DEPTNO should be listed second, allowing DB2 to do a direct index lookup on the first column (EMPNO) and then a scan on the second (DEPTNO) for the greater-than.
然后列出DEPTNO，从而允许DB 2对第一列(EMPNO)执行直接索引查找，然后针对大于号扫描第二列(DEPTNO)。
The last table in the join sequence, CUST_CUSTOMER, is also scanned through an index defined over the CUST_CODE column.
联接序列中的最后一个表是cust_customer表，其也是通过CUST _ code列上已定义的索引进行扫描。
SYSSTAT views containing the table, column, and index statistics.
SYSSTAT视图，包含表、列和索引统计数据。
By adding the index on the ACCT_ID_INX column, the new access plan shows a significant cost reduction from 3420.41 to 38.6219 timerons.
通过在ACCT _ ID _ IN x列上添加索引，新的访问计划显示了从3420.41到38.6219timeron的较大成本缩减。
This method accepts five arguments: the row index, the column index, the cell value, the spreadsheet key, and the worksheet key.
该方法接受5个参数：行索引、列索引、单元格值、电子表格键和工作表键。
Suppose you have an index on the column customer_type in the customer table, and there are only five possible customer_type codes.
假设customer表中的customer _ type列上有一个索引，那么只会有5种可能的customer _ type代码。
To illustrate this, compare it to the predicate that is applied to the index scan numbered 5 in the plan, which is on the one and only column of the index on the child table.
为了展示这一点，将它与计划中第5号索引扫描上使用的谓词相比较，它针对子表中惟一的索引列。
应用推荐