该查询计划显示了一个全表扫描。
该查询计划显示了全表扫描。
使用分区修剪的表扫描(TBSCAN)。
当必须要搜索整个表时,就称为表扫描。
When the entire table has to be searched, it's called a table scan.
在这里,使用一个表扫描来访问行是更好的选择。
Accessing the rows using a table scan is a better choice in this case.
索引能够避免全表扫描,从而能够提高查询性能。
Indexes improve query performance by avoiding a full table scan.
还是如图11所示,每次执行查询都有两个表扫描。
Also as shown in Figure 11, you can see that there are still two table scans for each execution of the query.
这个报表查询需要该事实表的一个全表扫描。
This report query requires a full table scan of the fact table.
它们利用一个或多个XML索引完全避免表扫描。
They take advantage of one or multiple XML indexes to entirely avoid table scans.
这将允许下面两个查询来使用索引访问,而不是表扫描。
This will allow both of the following queries to use indexed access rather than table scans.
这比不使用任何索引的两个表扫描的嵌套循环连接要快得多。
This is a lot faster than a nested loop join of two table scans without any index usage.
执行索引分析,确保索引正确,从而能避免不必要的表扫描。
Perform index analysis to make sure that the right indexes exist to help avoid unnecessary table scans.
通过索引扫描还是表扫描来访问外部表则取决于该表。
The outer table can be accessed by an index scan or by a table scan, depending on the table.
可以从WHERE子句中提取确定性函数调用,避免不必要的表扫描。
Deterministic function calls can be extracted from the WHERE clause to avoid unnecessary table scan.
目前,要运行表上的RUNSTATS,就要执行全表扫描。
Currently, a full table scan is performed whenever RUNSTATS on table is run.
在缺少当前统计的情况下,优化器选择对参与联接的两个表进行表扫描。
The optimizer, in the absence of current statistics, is choosing to do a table scan on both tables involved in the join.
物理数据或键的连续性对于表扫描或键-索引扫描的速度十分重要。
Contiguity of physical data or keys is important to the speed of table scans or key-index scans.
如果该值很大,表示可以通过对谓词列创建索引来避免多余的表扫描。
A high value here can indicate excessive table scans that can be prevented by creating indexes on the predicate columns.
该例中,表扫描极其昂贵,因为Informix引擎必须随机地访问数据。
In this case, a table scan is very expensive, because the Informix engine has to access data randomly.
这使得DB 2查询使用表扫描代替索引扫描,并降低了数据库的性能。
This makes DB2 queries use table scans instead of index scans and degrades database performance.
因此,DB 2不能使用那些索引,而是会采取表扫描来确保正确的查询结果。
Thus, DB2 cannot use those indexes and resorts to a table scan to ensure a correct query result.
清单7中查询的谓词选择性较弱,因此需要对pdbxml表进行全表扫描。
The predicates in the query in Listing 7 are weakly selective so that a full table scan of the PDBXML table is required.
收集不依赖于连接(JOIN)的基本访问(表的索引扫描和表扫描)的计数。
Gather counts for base accesses (an index scan or a table scan of a table) that are not dependent on a join.
报告的表扫描次数表示在下午 1点到 2点之间在这个表上执行的扫描。
The number of table scans reported represents the scans on the table between 1:00 p.m. and 2:00 p.m.
它还针对完全表扫描(一个最常见—也最耗时—的商业智能查询访问模式)进行了优化。
It's also optimized for full table scans (one of the most common-and most time-consuming-business intelligence query access patterns).
由于INSERT和select语句之间没有COMMIT,死锁可能是由表扫描引起的。
Since there is no COMMIT between the INSERT and SELECT statement, potentially the deadlock is caused by a table scan.
因为该select语句的结果集中只期望一行,所以表扫描在这里被认为是代价较高的操作。
Since only one row is expected in the result set from this SELECT statement, the table scan here is considered an expensive operation.
如果没有创建合适的索引,或者如果索引扫描的成本更高一些,优化器通常就选择表扫描。
The optimizer normally chooses a table scan if no appropriate index has been created or if an index scan would be more costly.
DB 2行压缩功能可以减少磁盘存储需求,同时改进执行全表扫描的大量查询的顺序读取访问。
DB2 row compression features can decrease disk storage requirements while at the same time improve sequential read access of large queries which perform full table scans.
表2总结了此次表扫描的性能如何能从我们的两个设计决策中受益:原子站点分离和压缩。
Table 2 summarizes how the performance of this table scan query has benefited from two of our design decisions: atom site separation and compression.
应用推荐