Index Fill Factors
- To Increase Performance Strive To Reduce Index Page Splitting, Merging and Shuffling
- High Insert/Update Activity Use FILLFACTOR Of 50 - 70, Avoids Splitting
- Select/Delete Activity Only Or Select Only Use FILLFACTOR Of 100, Avoids Merges/Shuffles