Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 318
  • Last Modified:

change index fillfactor

I have an index file group that is filling up a disk drive.  The fill factor is set to 80%.  I also have a job that rebuilds these indexes when the fragmentation gets beyond a certain percentage.  I want to change the fill factor so the index size will decrease.  Is this something that can be done without having to drop and recreate the entire index?
0
navajo26354
Asked:
navajo26354
1 Solution
 
lcohanDatabase AnalystCommented:
Yes if you do have ENTERPRISE edition you can use REBUILD with ONLINE=ON
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

Tackle projects and never again get stuck behind a technical roadblock.
Join Now