磁盤排序 的英文怎麼說
中文拼音 [cípánbèixù]
磁盤排序
英文
disk sorting-
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工作負載中表掃描和表排序的數量較多,所以為獲得最佳性能將數據從磁盤預取到內存是很重要的。The database files used to store the database are sorted by a disk device, and a reader thread is assigned to each device
用於存儲數據庫的數據庫文件按磁盤設備排序,並給每個設備指派讀取器線程。Never physically swap disks in an attempt to reorder the boot devices
不要試著通過物理地交換磁盤來重新排序引導設備。The database and transaction log files are sorted by disk device, and a separate worker thread is assigned to each disk device
按磁盤設備排序數據庫和事務日誌文件,並給每個磁盤設備指派單獨的工作線程。Disk sort merging
磁盤排序合併This removes fragmentation, reclaims disk space by compacting the pages based on the specified or existing fill factor setting, and reorders the index rows in contiguous pages
這將根據指定的或現有的填充因子設置壓縮頁來刪除碎片、回收磁盤空間,然後對連續頁中的索引行重新排序。In doing this, fragmentation is removed, disk space is reclaimed by compacting the pages using the specified or existing fill factor setting, and the index rows are reordered in contiguous pages allocating new pages as needed
此過程中將刪除碎片,通過使用指定的或現有的填充因子設置壓縮頁來回收磁盤空間,並在連續頁中對索引行重新排序(根據需要分配新頁) 。A stripe set is a disk file system, on which data is divided into blocks and spread in a fixed order among all disks in a disk array
」是一個磁盤文件系統,在該系統上,數據分為若干個塊,並在磁盤數組中的所有磁盤上按照固定順序排列。No additional space is required except for temporary disk space for sorting, which is typically 20 percent of the index size
除了用於排序的臨時磁盤空間外,不需要額外的空間。這通常是索引大小的20 % 。分享友人