扫描索引用英语怎么说,扫描索引的英文翻译


词语导航

基本信息

词语:扫描索引

繁体:掃描索引

拼音:sǎo miáo suǒ yǐn

英语翻译

【计】 scanning index

分词翻译

扫描的英语翻译:

scan; scanning
【计】 fineness; scanning
【医】 scanning

索引的英语翻译:

index; reference
【计】 X
【医】 index

翻译例句

1. 仅扫描索引是未包含表访问的索引访问,因为索引本身包含了所有被请求的数据。

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.

2. MON_GET_INDEX表函数和db2pd实用程序提供相同的索引度量指标(扫描索引和仅扫描索引的数量)。

The MON_GET_INDEX table function and db2pd utility provide the same index metrics (number of index scans and index only scans).

3. 除了scans列之外,db 2 pd实用程序的TCBIndexStats部分还有一个ixonlyscns列,它显示仅扫描索引的数量。

In addition to the scans column, the TCB index Stats section of the db2pd utility results has a IxOnlyScns column that shows the number of index only scans.

4. 在我们的例子中,通过索引扫描得到6574个候选行。

In our example, we get 6574 candidates from the index scan.

5. 一般来说,索引扫描是访问数据的最有效的方法,尤其是表很大但符合条件的行很少的时候。

Index scans are usually the most efficient way to access data, especially when the table is large but the number of qualified rows is small.

6. 因为其是一个唯一索引扫描,所以在访问路径图中不显示FETCH或表节点。

There is no FETCH or table node shown in the access path graph because it is an index-only scan.

7. 有了新建的索引,所有表都可以用索引扫描访问。

With the newly created indexes, all tables are accessed with index scans.

8. 以上示例展示了如何使用连续扫描和索引来进行数据检索,以及如何使用嵌套循环连接方法来连接所有表。

The above example shows that sequential scan and indexes are used to do the data retrieval, and the nested-loop join method is used to join all tables.

9. 或者DB 2必须计算两个索引扫描的交集,通常这样做的开销将相当高。

Instead DB2 needs to compute the intersection two index scans, which is often significantly more costly.

10. 当客户机读取一个文件之后,就对这个页面的内容进行扫描,这与索引程序的情况相同。

After a file is read by the client, the page could also be scanned for content, as in the case of an indexer.

11. 该选项以筛选的方式用于非匹配索引扫描,且是仅索引访问的一部分。

The option can be used in non matching index scans in a screening fashion and as part of index-only access.

12. 该准则指定一个单一的xml索引扫描,将用于访问给定的表。

This guideline specifies that a single XML index scan be used to access the given table.

13. 不管数据行是否被提交,以及根据语句的谓词它是否被排除,对于索引扫描和表访问都执行这样的锁定操作。

This locking was done for both index scans and table access whether or not the row of data was committed or whether it would have been excluded based on the statement"s predicates.

14. 两个本地谓词无法从匹配或筛选现有的索引扫描中获益。

The two local predicates cannot benefit from matching or screening index scans from any of the existing indexes.

15. 优化器中的多索引扫描是OLTP的另一大赢点。

Multiple index scans in the optimizer are another big win for OLTP.

16. 当扫描一个mdc表时,对于索引扫描,块锁可以推迟。

When scanning an MDC table, block locking could be deferred for an index scan.

17. 全局索引保留来自索引扫描的顺序属性,这是相对于本地索引的一个优势。

Global indexes preserve the order property from index scans, and this gives them an edge over local indexes.

18. 索引扫描可以是非匹配的,这意味着在基础索引的扫描上没有限制。

An index scan can be non-matching, which means that there are no restrictions in the scan of the underlying index.

19. 如果将其值设置为0,那么当存在合适的索引时,优化器就选择索引扫描而非表扫描,甚至不考虑估算成本。

If the value is set to 0, then the optimizer chooses index scans over table scans if appropriate indexes exist, without even considering the estimated costs.

20. 这使得DB 2查询使用表扫描代替索引扫描,并降低了数据库的性能。

This makes DB2 queries use table scans instead of index scans and degrades database performance.WWW.wEnTiyi.coM

21. 该查询计划显示索引扫描使用了函数索引。

This query plan shows an index scan using our functional index.

22. 如果没有创建合适的索引,或者如果索引扫描的成本更高一些,优化器通常就选择表扫描。

The optimizer normally chooses a table scan if no appropriate index has been created or if an index scan would be more costly.

23. 对于多索引下推,多索引扫描用于组合来自不同索引扫描的RID,然后就可以执行对事实表的跳跃式扫描了。

For multiple index push-downs, multi-index scan is used to combine RIDs from different index scans, then skip-scan on the fact table is performed.

24. 如果没有索引满足所取的行的要求顺序,或者优化器断定排序的代价低于索引扫描,那么就需要进行排序。

Sorting is required when no index satisfies the requested ordering of fetched rows, or the optimizer determines that a sort is less expensive than an index scan.

25. 访问计划指示,强制优化器使用指定的访问方法进行数据检索,要么是连续扫描,要么是索引扫描。

Access plan directives that force the optimizer to use the designated access method for data retrieval, either sequential scan or index scan.

26. A:索引查找利用全局索引扫描,来确定对分区的引用是否存在。

A: With global index scans, the index look-up determines whether a reference to a partition exists.

27. 例如,使用不正确的谓词会妨碍优化器使用索引扫描,即使在索引可用的情况下。

For example, improperly coded predicates might prevent the optimizer from using an index scan even when the index is available.

28. 这个值越低,优化器就越有可能选择扫描网格索引。

The lower this value is the more likely the optimizer will choose to scan the grid index.

29. 这意味着对表的顺序扫描比索引读取更快,我们无法遵循指示器标准。

This means that a sequential scan of the table will be faster than an indexed read, and we cannot play with the filter criteria.

30. 类似于现有的用于关系索引的关系索引扫描操作符(IXSCAN),XISCAN操作符在xml索引上执行查找或扫描。

Like the existing relational index scan operator for relational indexes (IXSCAN), the XISCAN operator performs lookups or scans on XML indexes.

版权声明:问题易所有作品(图文、音视频)均来源网络,版权归原创作者所有,与本站立场无关,如不慎侵犯了你的权益,请联系我们告知,我们将做删除处理!