Difference between PAD_Index and FillFactor ?

 Posted by PandianS on 12/16/2010 | Category: Sql Server Interview questions | Views: 5140 | Points: 40
Answer:

PAD_Index : When we create or modify an index, The percentage of free space allocated in the INTERMEDIATE LEVEL pages during the operation.

FillFactor :When we create or modify an index, The percentage of free space allocated in the LEAF LEVEL of each index page during the operation.


| Alert Moderator 

Comments or Responses

Login to post response