What is PAD_INDEX?

 Posted by Niladri.Biswas on 4/26/2013 | Category: Sql Server Interview questions | Views: 2761 | Points: 40
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 

Comments or Responses

Login to post response