此事件的处理程序接收鼠标指针所在位置的列索引和行索引。
The handler for this event receives the column index and row index of the mouse pointer position.
如果您通过表的行索引或列索引检索值,将无法设置返回值。
If you retrieve the value by means of the table's row index or column index, you will not be able to set the return value.
不过,如果左右两侧都是散列索引,而用户可能希望主视图是有序的。
However, if both of them are hash indexes, the user may want the main view to be ordered.
该方法接受5个参数:行索引、列索引、单元格值、电子表格键和工作表键。
This method accepts five arguments: the row index, the column index, the cell value, the spreadsheet key, and the worksheet key.
要求两个索引值来查找数据:列索引和行索引,和其他一样都是从0开始。
It requires two indices to locate an element: a column index and a row index, both of which are zero-based like everything else in LabVIEW.
索引下推只需要事实表的单列索引,虽然在所需的外键列是索引的第一个键的情况下可以使用多列索引。
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.
如果查询中有属于多列索引的连接列或过滤列,则使用UPDATESTATISTICSHIGH。
Use UPDATE STATISTICS HIGH if queries have a multi-column indexed defined on join columns or filter columns.
为了便于讨论,我们选择的索引是一个三列索引,名为IX1,在(COLA,COLB,COLC)上创建。
For the purposes of discussion, our chosen index is a three-column index called IX1 created on (COLA, COLB, COLC).
这些编目描述了数据库对象,例如表、列和索引,并包含关于用户所拥有的访问这些对象的访问类型的信息。
The catalog describes the database objects, such as tables, columns, and indexes, and contains information about the types of access that users have to these objects.
因此,整个数据列和相关的索引不是存储在数据库中。
Thus, whole columns of data and the associated indices are not stored in the database.
当超过这个限度后,确实存在性能影响。有一些方法可以克服这个限度,就是使用索引列和视图。
There are definitely performance impacts when exceeding this limit and there are ways to overcome this limit by using indexed columns and views.
例如,您可以决定哪些索引或列将受到处理过程的影响。
For example, you can influence which indexes or columns are affected by the processing.
它将查询数据库,为结果的每行中的每列建立索引,并且将每个索引条目绑定到行的主键上。
It queries your database, indexes each column in each row of the result, and ties each index entry to the row's primary key.
为此,索引列是一个包含索引的单列,或者是复合索引中指定的第一个列。
For this purpose, an indexed column is any single column with an index or the first column named in a composite index.
关于列定义、索引以及昵称统计信息的信息存储在DB 2联邦数据库系统编目中。
Information about the column definitions, index, and statistics for a nickname is stored in the DB2 federated database system catalogs.
此处,我们必须在所选列在树中出现的位置找到该列的索引。
Here you must find the index of the column in the position as it appears in the tree.
但是,关系谓词不能应用于底层的xml列或它的索引。
But, relational predicates cannot be applied to the underlying XML column or its indexes.
最后,可以根据列编号为这些列建立索引,并直接强制转换结果(对于某些类型)。
Finally, you can index into the columns by column number and cast the results directly (for some types).
任何利用主索引列的查询将会遭遇更快速响应时间问题。
Any query that utilizes the Primary Index column will encounter faster response times.
其次,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.
确保查询中进行连接操作的列都有索引。
Ensure that columns that are joined in queries have indexes.
也可以将经常被访问的数据作为include子句中的列包含在索引中。
Frequently accessed data can also be included within an index as included columns.
定义惟一索引的索引规范还将关于索引列惟一性的信息传递给联邦系统。
An index specification that defines a unique index also conveys information about the uniqueness of the index columns to the federated system.
最后,如果可能的话,将SELECT中所有的列包括到索引当中,这样就不需要访问表中的行。
Finally, if possible, include all of the columns in the SELECT in the index, so that there is no need to access the table rows.
因此,您常常可以选择实现只包括在WHERE和ORDERBY子句中引用到的列的索引。
Therefore, you may often choose to implement indexes that include only the columns referred to in the WHERE and ORDER BY clauses.
编写报告时,要尽可能确保利用具有索引的列。
When authoring reports, be sure to leverage columns that have indexes wherever possible.
如果该值很大,表示可以通过对谓词列创建索引来避免多余的表扫描。
A high value here can indicate excessive table scans that can be prevented by creating indexes on the predicate columns.
关系索引的数据类型始终由索引列的类型来确定。
The data type of relational indexes is always determined by the type of the indexed column.
结果集中的id列建立起索引条目与文本值之间的关系。
The ID column in the result set establishes the relationship between index entry and the text value.
结果集中的id列建立起索引条目与文本值之间的关系。
The ID column in the result set establishes the relationship between index entry and the text value.
应用推荐