每个索引分区仅从相应的数据分区取得索引行。
Each index partition indexes rows only from the corresponding data partition.
确定了此索引后,也就知道了项的数量,也就能够确定小计行之后元素的索引了。
When you have determined this index, you then know the number of items, and you can determine the indexes of the elements occurring after the subtotal line as offsets.
接下来,创建一个查询以生成要被索引的行。
IDS允许应用程序开发人员将锁放在不同的对象上,如数据库、表、页或行、以及索引。
IDS allows application developers to place locks on different objects, like databases, tables, pages or rows, and indexes.
缓冲池是内存中的一块存储区域,用于临时读入和更改数据库页(包含表行或索引项)。
A buffer pool is an area of storage in memory into which database pages (containing table rows or index entries) are temporarily read and changed.
下面浏览一下表1中的行,来研究每个谓词的索引合格性。
Now step through the rows in Table 1 to explore index eligibility for each predicate.
相关子查询将极大地降低数据检索的速度,对于拥有几百万个行但没有索引的大型表的非选择性查询更是如此。
Correlated subqueries will greatly degrade the speed of data retrieval, especially for non-selective queries on huge tables with millions of rows and with no index.
优化器然后使用复合索引将临时表连接到事实表,来快速定位在维度表中满足条件的行。
The optimizer will then join that temp table to the fact table using the compound index to quickly locate the rows that satisfy the criteria on the dimension tables.
XANDOR操作符使用这些XISCAN 来轮流检查两个索引,以便有效地找到同时匹配两个谓词的文档的行ID。
The XANDOR operator uses these XISCANs to alternately probe into the two indexes to efficiently find the row IDs of the documents that match both predicates.
数据块的这部分包括了表和索引的数据。一条数据行是可以跨多个数据块的。
This portion of the data block contains table or index data. Rows can span blocks.
其他三个低位字节称为记录标识符 (RID),其中包含标记的MSB 所引用的元数据表中的行索引。
The lower three bytes, referred to as the record identifier (RID), contain the index of the row within the metadata table to which the token's MSB refers.
如果从一个带有10个索引的表删除一行,DB 2必须删除与被删除的行关联的所有索引条目。
Delete a row from a table with 10 indexes, and DB2 must remove all index entries associated with the deleted rows.
本质上,该索引器的目的是返回一个与绘制面上已知的行和列相对应的点。
Basically, the purpose of this indexer is to return a point corresponding to a given row and column on the drawing surface. Follow these steps.
第三个命令抽取 15%的行,但是不收集分布统计信息,并对索引也应用了抽样,这不同于第一个命令和第二个命令。
The third command samples 15% of all rows, does not collect distribution statistics, and also applies sampling to indexes which the first and second commands didn't.
理想情况下,索引提供了足够多的信息,可以只读入所需要的行,但是有时候查询(设计不佳或数据本性使然)需要读取表中大量数据。
Ideally, the indexes provide enough information to read in only the needed rows, but sometimes queries (through poor design or the nature of the data) require large chunks of the table to be read.
特别是,读取和选中的行之间的比率会告诉您是否所有sql语句都正在有效地使用索引。
In particular, the ratio between rows read and selected can tell if all SQL statements are using indexes efficiently.
第20 - 26行只是将参数转换为色彩值,大小和索引属性。
Lines 20-26 simply convert the arguments passed into the correlating values for the color, size, and index properties.
然后,DB 2可以根据预期顺序,也就是索引顺序,向程序返回符合条件的行。
DB2 can then return qualified rows to the program in the desired order, the order of the index.
其次,可以发现查询4和查询5对应的行拥有同样的条目,且索引idx4和idx5对应的列也拥有同样的条目。
Next, you see that the rows for query 4 and query 5 have identical entries, and the columns for indexes idx4 and idx5 also have identical entries.
JDBC适配器使用 object_key作为对客户表的索引,以检索更改的行。
The JDBC adapter uses the object_key as an index into the Customer table to retrieve the changed row.
我们选择的索引位于(COLA,COLB,COLC)上,因此那些谓词—上面的示例中的前三行—将以那个顺序应用。
Our chosen index is on (COLA, COLB, COLC), so those predicates-the first three lines in the preceding example-will be applied in that order.
表2中每一行用于一个查询,每一列分别用于前面定义的索引idx3到idx6。
Table 2 has one row for each of these three queries, and one column for each of the indexes idx3 through idx6 defined above.
XISCAN 使用路径值对(/book/price,29) 来检查索引,并返回其中价格为 29的文档的行ID。
The XISCAN probes the index with the path-value pair (/book/price, 29) and returns the row IDs for documents where the price is 29.
接下来,参赛者需要向每个表添加合适的索引,以便Informix无需扫描整个表即可找到它需要更新的行。
Next, contestants needed to add appropriate indexes to each table, so that Informix would not scan the whole table to find the row it needed to update.
如果在sql语句的select子句的XMLQUERY函数中使用xml谓词,则这些谓词不会从结果集中排除任何行,因此不能使用索引。
If you use XML predicates in the XMLQUERY function in the select clause of an SQL statement, these predicates do not eliminate any rows from the result set and therefore cannot use an index.
探测扫描的数目。探测扫描用于直接在索引或基表中查找行。
Number of probe scans. A probe scan is used to directly look up rows in an index or base table.
我们创建了这些索引,因为样例数据库中的FPMLADMIN. FPML43表有4MB,包含近900行。
We created these indexes because the FPMLADMIN.FPML43 table in the sample database is 4mb and contains nearly 900 rows.
数据库服务器首先通过查找索引中的行,定位表中的相关行。
The database server locates relevant rows in the table by first finding the row in the index.
正如在关系数据库中那样,BigTable中的数据可以组成具有行和列的表,且每一行都有一个惟一的索引id。
As in a relational database, data in BigTable can be organized into tables with rows and columns, and each row has a unique indexed ID.
结果,该引擎必须读取很多数据行然后使用实际行数据应用最终过滤,即使过滤列的索引可用。
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.
应用推荐