| 1. | User - specified fillfactor values can be from 1 through 100 用户指定的fillfactor值可以是1到100 。 |
| 2. | 0 fillfactor percentage used when the index was created or rebuilt > 0 =创建或重新生成索引时使用的fillfactor百分比。 |
| 3. | The fillfactor setting applies only when the index is created or rebuilt Fillfactor设置仅在创建或重新生成索引时应用。 |
| 4. | The level of fullness can be configured by using the fillfactor option in create index 填充度可以使用create index中的fillfactor选项进行配置。 |
| 5. | An explicit fillfactor setting applies only when the index is first created or rebuilt 显式的fillfactor设置只是在索引首次创建或重新生成时应用。 |
| 6. | 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 ,则使用 |
| 7. | The percentage of free space that is specified by fillfactor is applied to the intermediate - level pages of the index Fillfactor指定的可用空间百分比应用于索引的中间级页。 |
| 8. | Also , alter index reorganize will compact an index by trying to fill pages to the fillfactor that was last specified 此外, alter index reorganize还试图通过将页填充到上一次指定的fillfactor来压缩索引。这会增加 |
| 9. | Rebuilding an index with the fillfactor option specified allows the page fullness to be changed to fit the query pattern on the index 使用指定的fillfactor选项重新生成索引可以改变页填充度,以便符合索引中的查询模式。 |
| 10. | 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所指定的百分比。 |