March 12, 2009 at 3:51 pm
Hello all,
quick question, sql 2005 maint. plan would not let you specify fill factor for re-indexing job.
Would this be safe to assume, that it will use server default fill factor?
Thank you
March 12, 2009 at 4:41 pm
If you rebuild the index without specifying the fill factor explicitly then it will take the value stored in sys.indexes...i.e. the value specified when the index was created (or the last time it was rebuilt using an explicit fillfactor). If you don't specify a value for the fillfactor when creating the index, i beleive it will use the default server value
Gethyn Elliswww.gethynellis.com
March 12, 2009 at 4:57 pm
pobeda (3/12/2009)
Hello all,quick question, sql 2005 maint. plan would not let you specify fill factor for re-indexing job.
Would this be safe to assume, that it will use server default fill factor?
Thank you
Hmmm I think you might be getting the Maintenance Plan tasks confused ..
You have two tasks in SQL Server 2005 for Indexes Maintenance.
1) Rebuild Index Task
- If you want to change the fill factor of the index this is the task you should use. As only by rebuilding the index can you change the fill factor.
2) Reorganize Index Task
- If it is just leaf nodes you are worried about in index then this task; since you are only reorganizing you cannot change fill factor.
Thanks.
Mohit.
Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
Microsoft FTE - SQL Server PFE
* Some time its the search that counts, not the finding...
* I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. :smooooth:[/font]
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply