Reserving free spaces for indexes
You might reduce performance problems that result from index page splits by reserving free space when you reorganize the indexes.
About this task
When sufficient free space is unavailable in an index space, index page splits can result and performance might suffer.
With the introduction of fast storage hardware that enable fast list prefetch, index organization becomes less important. A disorganized index is likely to have plenty of free space. Therefore, you do not need to reorganize indexes for the purpose of creating free space.
However, free space remains an important consideration whenever you do reorganize your indexes.
Procedure
To manage free space for indexes, use the following approaches: