必须找到列索引来提取该列的文本内容。
The column index must be found to extract the textual contents of the column.
因此,Cell对象通过Row对象中的列索引进行散列化。
Thus, the Cell objects are being hashed with the column index in the Row object.
此事件的处理程序接收鼠标指针所在位置的列索引和行索引。
The handler for this event receives the column index and row index of the mouse pointer position.
该方法接受5个参数:行索引、列索引、单元格值、电子表格键和工作表键。
This method accepts five arguments: the row index, the column index, the cell value, the spreadsheet key, and the worksheet key.
如果查询中有属于多列索引的连接列或过滤列,则使用UPDATESTATISTICSHIGH。
Use UPDATE STATISTICS HIGH if queries have a multi-column indexed defined on join columns or filter columns.
索引下推只需要事实表的单列索引,虽然在所需的外键列是索引的第一个键的情况下可以使用多列索引。
Index push-downs require only a single-column index on the fact table, although they can use a multi-column index if the required foreign-key column is the first key in the index.
为了便于讨论,我们选择的索引是一个三列索引,名为IX1,在(COLA,COLB,COLC)上创建。
For the purposes of discussion, our chosen index is a three-column index called IX1 created on (COLA, COLB, COLC).
对于本文中的查询,收集了引用表、列、索引的统计数据,如表基数、列基数等等。
For the query in this article, the basic statistics of the referenced tables, columns and indexes were collected, such as the table cardinality, column cardinality, an so on.
然后,DB2可以以 “传统”方法(索引、表、索引、表,等等)使用这个 “4列” 索引以期望的次序(与索引相同或相反的顺序)返回所需行。
then DB2 could use the four-column index the "traditional" way (index, table, index, table, etc.) to return the rows in the desired order (the same order as or the reverse order of the index).
这份地图所使用的符号全部列在索引中。
当索引列的顺序是随机的时候,将会发生什么呢?
将这些列放在索引的开始部分。
确保查询中进行连接操作的列都有索引。
Ensure that columns that are joined in queries have indexes.
为应用程序将查询或更新的列创建索引。
Create indexes for the column that your application is querying or updating.
它们还可以存储结构化类型的列或索引数据。
按照您想应用索引列谓词的顺序创建您的索引。
Create your indexes in the order in which you want those index column predicates applied.
为了提高搜索性能,第一个列将被索引。
For increased search performance, the first column is indexed.
主键列、外键列和索引上使用的列的数据类型。
Data type of primary key columns, foreign key columns, and columns used on indexes.
最后,可以根据列编号为这些列建立索引,并直接强制转换结果(对于某些类型)。
Finally, you can index into the columns by column number and cast the results directly (for some types).
SYSSTAT视图,包含表、列和索引统计数据。
SYSSTAT views containing the table, column, and index statistics.
如果该值很大,表示可以通过对谓词列创建索引来避免多余的表扫描。
A high value here can indicate excessive table scans that can be prevented by creating indexes on the predicate columns.
为此,索引列是一个包含索引的单列,或者是复合索引中指定的第一个列。
For this purpose, an indexed column is any single column with an index or the first column named in a composite index.
但是如果索引列的顺序是随机的,将会发生什么呢?
But what happens when the order of the index column is random?
为xml列提供xml索引。
我们还从创建关于EMPNO和deptno列的索引开始。
And we also started by creating an index on the EMPNO and DEPTNO columns.
示例13:收集构成索引的所有列以及两个非索引列中包含分布的目录统计信息。
Example 13: Collect catalog statistics with distribution on all columns that are part of the index, plus two columns that are not.
因此,您常常可以选择实现只包括在WHERE和ORDERBY子句中引用到的列的索引。
Therefore, you may often choose to implement indexes that include only the columns referred to in the WHERE and ORDER BY clauses.
关于列定义、索引以及昵称统计信息的信息存储在DB 2联邦数据库系统编目中。
Information about the column definitions, index, and statistics for a nickname is stored in the DB2 federated database system catalogs.
它将查询数据库,为结果的每行中的每列建立索引,并且将每个索引条目绑定到行的主键上。
It queries your database, indexes each column in each row of the result, and ties each index entry to the row's primary key.
关系索引的数据类型始终由索引列的类型来确定。
The data type of relational indexes is always determined by the type of the indexed column.
应用推荐