Fill Factor in Indexes

What is fill factor?
What should be the ideal value of fill factor for any index?
Justify the answer.

Questions by psingla   answers by psingla

Showing Answers 1 - 2 of 2 Answers

raiyaans

  • Jan 11th, 2012
 

The fill factor simply says how large or how full to get our index pages
you can set it as 70% ,

If set to 100% it might me a bad thing if we had a lot of DML activity but if this is a read only table then
fill factor=100% is fine.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions