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秒)。
It will choose indexed access if it has lower cost than table scan.
如果使用索引的开销比表扫描的开销低,优化器将选择索引访问。
However, if no indexes are available, the query optimizer must use a table scan.
但如果没有索引,则查询优化器必须扫描表。
A table scan will occur when the code is executed.
执行代码后将进行表扫描。
A table scan will occur when the code is executed.
执行代码后将进行表扫描。
应用推荐