Fill factor in Index

Posted Date: 27 Oct 2009	Resource Type: Articles	Category: Databases
Author: Rajesh.Dharmakkan	Member Level: Gold
Rating:	Points: 5

Fill factor in Index

Fill factor this is the concept consider while creating an index. The fill factor specifies the amount of space occupied for data storage. Fill factor must be the integer value between 0 to 100.
If the fill factor is 100 then the full file is rearranged based on the index column and save in a single page. In general the fill factor set as 100 only for the table which should remain same without ant change in future. If any value inserted into the table which have the fill factor value 100, the new row will be inserted into the new location. The existing table values and new values are saved in different location. The fetching values become little bit degrade.

If the table needs to modify or insert new row then base on the fill factor value should set.
If the table will modify frequently then the fill factor value should be in 5 to 10. The remaining 95 to 90 percent of space remains empty to accept the new changes or new row insert. The full table values are saved in continuous. This is easy to fetch.

Responses

No responses found. Be the first to respond and make money from revenue sharing program.

Feedbacks

Popular Tags

What are tags ?

Search Tags

Index fill factor . Index . FillFactor . Fill factor in sql server . Fill factor in Index . Fill factor .

Post Feedback

This is a strictly moderated forum. Only approved messages will appear in the site. Please use 'Spell Check' in Google toolbar before you submit.
You must Sign In to post a response.

	Next Resource: Checking Sql server Database
	Previous Resource: Usage of sp_executesql Procedure
	Return to Discussion Resource Index
	Post New Resource
	Category: Databases

Post resources and earn money!

More Resources