SQL Server Performance Forum – Threads Archive

Pad Index

Hi We are designing a database and the Indexes are being
created . In the Index the Pad_Index is taking the
default value of the Fill Factor. We for some reasons want to keep different values for PAd_Index
and Fill_Factor . Please suggest a way to do this Thanx in Advance

---

The PAD_INDEX option is useful only when FILLFACTOR is specified, because PAD_INDEX uses the percentage specified by FILLFACTOR. _________
Satya SKJ
Moderator
SQL-Server-Performance.Com

---

Yeah but can we keep say fill factor = 70 %
and pad_Index = 80% ?

---

I don’t think its possible to define different values. _________
Satya SKJ
Moderator
SQL-Server-Performance.Com

---

Without the PAD_INDEX clause, SQL Server creates leaf pages that are x percent full, but the pages above the leaf level are filled almost completely. With PAD_INDEX, the intermediate pages are also x percent full. ("creating index" from Books Online.

---

Do you know whether you can maintain different values for PAD_Index and FF, I don’t think so. _________
Satya SKJ
Moderator
SQL-Server-Performance.Com

---

No you can’t There is no pad_index=% option for create index… Cheers
Twan

---

Thats for I’m sure but it helps with a cross-check. _________
Satya SKJ
Moderator
SQL-Server-Performance.Com

---

]]>