full table scan
常見(jiàn)例句
- The predicates in the query in Listing 7 are weakly selective so that a full table scan of the pdbxml table is required.
清單 7 中查詢的謂詞選擇性較弱,因此需要對(duì) pdbxml 表進(jìn)行全表掃描。 - Most often, you want only a small subset of the data in the table, so a full table scan wastes a lot of disk I/O and therefore time.
通常來(lái)說(shuō),您可能只希望獲得表中數(shù)據(jù)的一個(gè)子集,因此全表掃描會(huì)浪費(fèi)大量的磁盤 I/O,因此也就會(huì)浪費(fèi)大量時(shí)間。 - If there is no index on ucname, the DBMS still does a full table scan, but it need not do any further processing on the data to determine whether or not it satisfies the query.
如果沒(méi)有為 ucname 創(chuàng)建索引,DBMS 仍然執(zhí)行全表掃描,但是不會(huì)對(duì)數(shù)據(jù)進(jìn)行進(jìn)一步處理來(lái)判斷其是否滿足查詢。 返回 full table scan