English translation for "扫描表"

scan table

Example Sentences:

	1.	However , if no indexes are available , the query optimizer must use a table scan 但如果没有索引，则查询优化器必须扫描表。
	2.	A table scan generates many disk i o operations and can be resource intensive 扫描表会有许多磁盘i / o操作，并占用大量资源。
	3.	The method may be a table scan , or may be scanning one or more indexes if they exist 可能采用的方法包括扫描表和扫描一个或多个索引（如果有） 。
	4.	If you build the index immediately , the table space is scanned , which can take a considerable amount of time 如果立即建立索引，则需要扫描表空间，这样要花费比较多的时间。
	5.	For queries that scan part or all of the indexes of a table , this kind of fragmentation can cause additional page reads 对于扫描表的部分或全部索引的查询，这种碎片会导致附加的页读取。
	6.	When performing a table scan , the query optimizer reads all the rows in the table , and extracts the rows that meet the criteria of the query 扫描表时，查询优化器读取表中的所有行，并提取满足查询条件的行。
	7.	However , a table scan could be the most efficient method if , for example , the result set of the query is a high percentage of rows from the table 但是，如果查询的结果集是占表中较高百分比的行，扫描表会是最为有效的方法。
	8.	The fullscan clause specifies that all data in the table is scanned to gather statistics , whereas the sample clause can be used to specify either the percentage of rows to sample or the number of rows to sample Fullscan子句指定扫描表中的所有数据来收集统计信息，而sample子句用来指定采样的行数百分比或采样的行数。
	9.	The optimizer will soon detect that you may retrieve 98 percent of the data in the table , and it thinks it is more efficient to read or scan the table sequentially rather than to traverse an index and subsequently the data pages , and then to retrieve the related data 优化器将立刻检测您可能要检索的表中的98 %的数据，它认为连续读或扫描表要比遍历索引（以及随后的数据页）更加高效，然后它将检索相关数据。

Similar Words：

"扫描标度" English translation, "扫描标记发生器" English translation, "扫描标志发生器" English translation, "扫描标志信号发生器" English translation, "扫描标准" English translation, "扫描病毒" English translation, "扫描播放" English translation, "扫描波束电流" English translation, "扫描波束制导" English translation, "扫描波形" English translation