表掃描 的英文怎麼說
中文拼音 [biǎosǎomiáo]
表掃描
英文
table scan-
It will choose indexed access if it has lower cost than table scan
如果使用索引的開銷比表掃描的開銷低,優化器將選擇索引訪問。Now, while printing guarantee slips for clients, staff first scan the original client insurance applications into the image system of the machine, and extract them to the printing servers, so that they can be printed together with formal invoices, company seals, customer - built covers, and pre - designed insurance items. the printed documents are bound into brochures to be handed to clients
現在,在列印客戶投保單時,工作人員將首先把原始的客戶保險申請表掃描到機器影像系統,並抽取到列印服務器,以連同正式發票公司印章定製封面封底和預先設定好的各險種條款規定一起列印出來,列印后的資料再通過裝訂成冊提交到客戶手中。Aws cwi exam application form and moody china registration form must be scanned and emailed to moody china at least 1 week before the first training day
請務必在培訓開始前1周將填寫完整的< aws焊接檢驗師考試申請表> 掃描並電郵至摩迪中國。Scientists at the university of wisconsin - madison combined satellite land cover images with agricultural census data from every country in the world to create detailed maps of global land use
威斯康辛-麥迪遜大學的科學家結合了衛星地表掃描影像和世界每個國家的農業普查資料,來製造全球土地運用地圖。Table scans always read and lock all the rows in the table
表掃描總是讀取(並上鎖)表中所有行。Cumulative count of range and table scans started on the index or heap
從索引或堆開始的范圍和表掃描的累積計數。Table scan behavior
表掃描行為Avoid indexing very small tables because it is typically more efficient to do a table scan
因為進行表掃描通常效率更高,所以要避免對非常小的表創建索引。The optimizer is more likely to choose a full table scan over an index if the value of this parameter is high
為什麼設置高了,優化器會選擇全表掃描而不選擇索引?This prevents a large table scan from completely dominating the buffer pool and adversely impacting random operations
這樣可以防止大規模的表掃描完全支配緩沖池,並惡劣地影響隨機操作。To save on i o operations, the query processor may choose to scan another index instead of performing a table scan
為了節省i / o操作,查詢處理器可以選擇掃描另一個索引,而不是執行表掃描。The optimizer, in the absence of current statistics, is choosing to do a table scan on both tables involved in the join
在缺少當前統計的情況下,優化器選擇對參與聯接的兩個表進行表掃描。With contiguous data pages, dms tablespaces allow for much more efficient operations such as sequential table scans than sms tablespaces do
Dms表空間通過連續的數據頁面支持比sms表空間要高效得多的操作,例如連續的表掃描。Because of the number of table scans and table sorts in the tpc - h workload, prefetching data from disks into memory is important for optimal performance
因為tpc - h工作負載中表掃描和表排序的數量較多,所以為獲得最佳性能將數據從磁盤預取到內存是很重要的。Specifies that the query optimizer use a table scan, one or more indexes, or a locking method with this table or view and for this select, insert, update, or delete statement
指定查詢優化器使用一個表掃描、一個或多個索引,或為當前表或視圖以及當前的select 、 insert 、 pdate或delete語句使用鎖定方法。The first example shows how to force the optimizer to use a nonclustered index to retrieve rows from a table, and the second example forces a table scan by using an index of 0
優化器提示的兩種方式。第一個示例說明如何強制優化器使用非聚集索引檢索表中的行,第二個示例使用索引0強制執行表掃描。This means that statistics tied to indexes, which are created with full scan when the index is built, require the whole table scan to be refreshed
這意味著,對于在生成索引時通過完全掃描創建的索引相關統計信息,將需要刷新整個表掃描。In a quick test on a table with 100, 000 rows loaded using a sequence, a normal index was used for most queries returning up to 30 rows, as was the reverse key index, however, when the number of rows went up to 1, 000, 000 the reverse key index was never used and a full table scan was used every time
在一個用一個序列載入並含100 , 000行的表上做一個快速的測試,分別用普通索引和逆序索引查詢並返回30行數據,當行數增長到1 , 000 , 000 ,將不再使用逆序索引而是每次使用全表掃描。The locklist and maxlocks would help determine the type of locks that will be held during a certain scan index scan or table scan, along with the isolation level
Locklist和maxlocks將幫助確定某掃描(索引掃描或表掃描)期間將持有的鎖類型,以及隔離級別。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
如果將其值設置為0 ,那麼當存在合適的索引時,優化器就選擇索引掃描而非表掃描,甚至不考慮估算成本。分享友人