Interview Questions
1. What are Points to remember while using the FILLFACTOR Argument?
Below are the criteria you need to consider while choosing fill factor.
- For static/look-up table: these types of tables have static data means data changes very rarely in the table. So we can set high value of fill factor means 100 or 0.
- For Dynamic table: In this type of table, data get changes (inserted/updated) frequently. So we need to set low fill factor, between 80 to 90.
- For Table with Clustered Index on Identity Column: Here the data is inserted at the end of the table always. So we can
have higher value of fill factor between 95 to 100.
Submit an interview question
Submitted questions and answers are subject to review and editing, and may or may not be selected for posting, at the sole discretion of w3Sniff.
Get Started
Comments
Leave a Comment