Difference between PAD_Index and FillFactor ?

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

Post |

Interview FAQs |

Exclusive Questions |

Interview Home

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