Answer:
It specifies whether the FILLFACTOR for the index should be applied to the nonleaf
data pages for the index. The PAD_INDEX option is used when data manipulation
language operations that lead to excessive nonleaf level page splitting need
to be mitigated.
Asked In: Many Interviews |
Alert Moderator