Basically, you set PAD_INDEX = ON if you expect a lot of random changes to the index regularly.
That helps avoiding index page splits.
I set it on when I expect 30%+ of random records included in the index to be deleted on a regular basis.
Basically, you set PAD_INDEX = ON if you expect a lot of random changes to the index regularly.
That helps avoiding index page splits.
I set it on when I expect 30%+ of random records included in the index to be deleted on a regular basis.