fillfactor 中文意思是什麼

fillfactor 解釋
填充系數
  1. Rebuilding an index with the fillfactor option specified allows the page fullness to be changed to fit the query pattern on the index

    使用指定的fillfactor選項重新生成索引可以改變頁填充度，以便符合索引中的查詢模式。
  2. When the fillfactor setting is 0 or 100, the leaf level is filled nearly to capacity, but some space remains for at least one additional index row

    Fillfactor設置為0或100時，葉級別幾乎完全填滿，但至少會保留一個其他索引行的空間。
  3. User - specified fillfactor values can be from 1 through 100

    用戶指定的fillfactor值可以是1到100 。
  4. 0 fillfactor percentage used when the index was created or rebuilt

    > 0 =創建或重新生成索引時使用的fillfactor百分比。
  5. The fillfactor setting applies only when the index is created or rebuilt

    Fillfactor設置僅在創建或重新生成索引時應用。
  6. The level of fullness can be configured by using the fillfactor option in create index

    填充度可以使用create index中的fillfactor選項進行配置。
  7. An explicit fillfactor setting applies only when the index is first created or rebuilt

    顯式的fillfactor設置只是在索引首次創建或重新生成時應用。
  8. If fillfactor is not specified at the same time pad index is set to on, the fill factor value stored in

    如果在pad _ index設置為on的同時不指定fillfactor ，則使用
  9. The percentage of free space that is specified by fillfactor is applied to the intermediate - level pages of the index

    Fillfactor指定的可用空間百分比應用於索引的中間級頁。
  10. Also, alter index reorganize will compact an index by trying to fill pages to the fillfactor that was last specified

    此外， alter index reorganize還試圖通過將頁填充到上一次指定的fillfactor來壓縮索引。這會增加
  11. The pad index option is useful only when fillfactor is specified, because pad index uses the percentage specified by fillfactor

    Pad _ index選項只有在指定了fillfactor時才有用，因為pad _ index使用由fillfactor所指定的百分比。
分享友人
分享到 Line

分享到臉書