But be careful with this tactic; you do not want to replicate a table in an index by including all of the table's columns in the index key.
但是要小心使用这一策略；您并不想以在索引键中包含数据表所有列的方式在索引中复制一个表。
The database server locates relevant rows in the table by first finding the row in the index.
数据库服务器首先通过查找索引中的行，定位表中的相关行。
An index only scan is an index access that is not followed by a table access because the index itself contains all the requested data.
仅扫描索引是未包含表访问的索引访问，因为索引本身包含了所有被请求的数据。
The optimizer ACTS based on statistical data about the number of rows in a table, the use of space by a table or index, and other information.
优化器的操作基于数据表中的行数、数据表或索引使用的空间以及其他信息的相关统计数据。
The two rightmost columns in table 1 represent two alternative index definitions, and the rows in the table show which of the predicates can (+) or cannot (-) be evaluated by either of the indexes.
表1最右侧的两列表示两个可选择的索引定义，表中各行展示了谓词可以(+)或不可以(-)由这两个索引进行计算。
SQL described tables and indexes can also be placed and moved by the corresponding ALTER TABLE or ALTER INDEX commands.
SQL描述的表和索引也可以通过对应的ALTERTABLE或 ALTERINDEX命令放置和移动。
You can explore all of these options on your own by right-clicking on the schema object (a table, view, index, or schema) to see which options are available for that particular object.
您可以通过在模式对象(表、视图、索引或模式)上单击右键自己探索这些选项，看看对于特定的对象有哪些可用的选项。
Is the whole table scanned or is it accessed by an index?
是否扫描了整个表或是否由索引访问？
These counters are incremented by the respective DML operation occurring on the partition, both table and index partitions.
这些计数器由表和索引分区中发生的各个DML操作实现值累加。
In general, a nested loop join with sort composite is favored by the optimizer if the inner index is well-clustered and the inner table is expected to be probed many times.
一般来说，如果内部索引是良好的集群且预测内部表被多次探测，则使用复合排序的嵌套循环联将受到优化器的青睐。
Otherwise, its data or keys will be scattered throughout the extents that have been occupied by the table or index.
否则，其数据或键将分散在该表或索引所占用的所有区段中。
The outer table can be accessed by an index scan or by a table scan, depending on the table.
通过索引扫描还是表扫描来访问外部表则取决于该表。
DB2 determines if a table or index reorganization by periodically checking tables and indexes that have had their statistics updated, and schedules such operations whenever they are necessary.
DB 2定期检查已经更新其统计信息的表和索引，判断它们是否需要重组，当需要时安排执行这些操作。
Uniqueness in the CCD table must be enforced — either by a primary key or unique index on the source table or CCD table.
ccd表中必须有惟一性约束——可以通过主键或者源表或ccd表上的惟一索引实现。
For instance, the purchaseOrders table is partitioned by po_date and has a local index on po_customer, the query below will need a sort after the index scan.
例如，表purchaseorders通过po_date进行了分区，并具有本地索引po_customer，以下查询在完成索引扫描后还需要进行排序。
The DBMS ensures that the index is always consistent with the data in the table by updating it during INSERT, UPDATE, and DELETE operations.
通过使用INSERT、UPDATE和DELETE操作对索引进行更新，DBMS能够确保索引始终与表数据一致。
Using this table function instead of db2pd simplifies evaluation of the results because the index IDs (IIDs) can be converted to index names by joining with the SYSCAT.INDEXES catalog view.
使用表函数取代 db2pd实用程序简化了结果计算，因为可以通过与 SYSCAT.INDEXES 目录视图结合将索引IDs (IIDs)转换成索引名。
Now, when creating partitioned tables, the partition boundaries are determined by the CREATE table statement instead of CREATE INDEX.
这时，当创建分区的表时，分区的边界由CREATEtable语句决定，而不是由CREATEindex语句决定。
The monthly composite index for ten cities, included for the first time in our table, fell by 1.9% in the year to March.
10所城市的综合月度指数至今年三月为止下跌了1.9%。《经济学家》首次将此指数收入图表中。
Listing 11. Table and index metrics as shown by the db2pd utility.
清单11.db 2 pd实用程序显示的索引度量指标。
This verifier includes the client timestamp - 1 (encrypted by conversation key) and the index ID in the server table for this client connection.
这个验证器包括客户端timestamp-1（由对话密钥进行加密）和索引 ID（位于这个客户端连接的服务器表中）。
This happens if the cursor has an ORDER BY clause that USES an existing index (a work table is not created).
如果游标有使用现有索引的ORDERBY子句(不必创建工作表)，会发生这种情况。
Besides reorganizing one or more indexes, large object data types (LOBs) that are contained in the clustered index or underlying table are compacted by default when an index is reorganized.
重新组织索引时，除了重新组织一个或多个索引外，默认情况下还将压缩聚集索引或基础表中包含的大型对象数据类型(lob)。
This naming convention also allows you, if looking at a list of indexes, to see the indexes ordered by table, then column, then index type.
索引一般与表或视图相关，所以使用表或者视图的名字来命名比较恰当，索引名等同于被索引字段名。
Besides, the search steps in probabilistic CYK algorithm is reduced and the probabilistic CYK algorithm is improved by rearranging grammar rules of SCNF and establishing the index table.
此外通过重排scnf语法规则和建立索引表对概率CYK算法进行改进，减少中间搜索步骤所需的时间以提高效率。
Each color in the palette is identified by its index number, or value, which corresponds to its position in the table.
调色板中的每种颜色都由其索引号或值来标识，它们与其在表中的位置相对应。
The indexes are assigned by expert experience method and average assignment method, and it is got the weight table of evaluation index.
通过专家经验法和平均赋值法对指标进行赋值，得到评价指标权重表。
Memory data are stored in table set, and data index is set up by hash table.
采用表集的方式存储各类内存数据，通过哈希表建立数据索引。
According to the features of the completed computed cube and the index structure in the kernel system, two types of plans on the cube are put forward by modifying the plans on the base table.
根据完全计算数据立方和索引结构的特点，对基于基表的方案进行修改，演化出基于数据立方的一般型和层次预分组型两种优化方案。
The fault codes are read by the glitter of the CRUISE indicator light and the correlative parts are inspected according to the index of the fault code table.
从CRUISE指示灯闪烁状态来读取故障代码，根据故障代码表中的提示去检测其相关的部位。
应用推荐