This report query requires a full table scan of the fact table.
这个报表查询需要该事实表的一个全表扫描。
This query plan shows a full table scan.
该查询计划显示了一个全表扫描。
Accessing the rows using a table scan is a better choice in this case.
在这里,使用一个表扫描来访问行是更好的选择。
When the entire table has to be searched, it's called a table scan.
当必须要搜索整个表时,就称为表扫描。
Currently, a full table scan is performed whenever RUNSTATS on table is run.
目前,要运行表上的RUNSTATS,就要执行全表扫描。
Scan customer table (6 seconds)
扫描customer表(6秒)
扫描state表(0秒)。
However, if no indexes are available, the query optimizer must use a table scan.
但如果没有索引,则查询优化器必须扫描表。
It will choose indexed access if it has lower cost than table scan.
如果使用索引的开销比表扫描的开销低,优化器将选择索引访问。
A table scan will occur when the code is executed.
执行代码后将进行表扫描。
A table scan will occur when the code is executed.
执行代码后将进行表扫描。
应用推荐