此事件的处理程序接收鼠标指针所在位置的列索引和行索引。
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.
主键列、外键列和索引上使用的列的数据类型。
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.
我们还从创建关于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.
结果,该引擎必须读取很多数据行然后使用实际行数据应用最终过滤,即使过滤列的索引可用。
As a result, the engine needed to read many rows of data and apply the final filters using the actual row data, even though indexes of the filter columns were available.
也可以将经常被访问的数据作为include子句中的列包含在索引中。
Frequently accessed data can also be included within an index as included columns.
其次,NNSTAT存储过程现在允许选择统计信息收集方法,并提供了对要为之收集统计信息的列和索引的细粒度的控制。
Secondly, the NNSTAT stored procedure now offers a choice of statistics-gathering methods, as well as fine-grained control over the columns and indexes for which statistics are to be collected.
定义惟一索引的索引规范还将关于索引列惟一性的信息传递给联邦系统。
An index specification that defines a unique index also conveys information about the uniqueness of the index columns to the federated system.
短语“关键列(key column)”表示构成表上所定义索引的列。
The phrase "key columns" means the columns that make up the indexes defined on the table.
但是,关系谓词不能应用于底层的xml列或它的索引。
But, relational predicates cannot be applied to the underlying XML column or its indexes.
因此,整个数据列和相关的索引不是存储在数据库中。
Thus, whole columns of data and the associated indices are not stored in the database.
例如,您可以决定哪些索引或列将受到处理过程的影响。
For example, you can influence which indexes or columns are affected by the processing.
编写报告时,要尽可能确保利用具有索引的列。
When authoring reports, be sure to leverage columns that have indexes wherever possible.
假设上面示例中的COL1列上有索引,如果对COL1而不是RHS执行类型转换,那么会绕过索引,查询会执行全表扫描。
If you assume that there is an index on COL1 in the above example, if COL1 is type-cast instead of the RHS, then the index will be bypassed and the query will perform a full table scan.
当超过这个限度后,确实存在性能影响。有一些方法可以克服这个限度,就是使用索引列和视图。
There are definitely performance impacts when exceeding this limit and there are ways to overcome this limit by using indexed columns and views.
应用推荐