Index Defrags

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: BoBl (anonymous_at_discussions.microsoft.com)
Date: 06/18/04 

Date: Fri, 18 Jun 2004 12:02:01 -0700

Say you've got a large table that you're no longer
reindexing but are using instead INDEXDEFRAG. Does
INDEXDEFRAG pad the pages with the FILLFACTOR?

This is important to me because it has a clustered index
so I want to make sure we're not getting page splits.

Also, does INDEXDEFRAG reclaim space that would occur
from any deletes that you've done in a table?

Relevant Pages

  • Re: Large Transaction Log Backup after Database Backup
    ... INDEXDEFRAG uses short transactions and doesn't ... >> Your database maintenance plan not only backs up the database, ... >> Reindexing is something you should do on a regular basis, ...
    (microsoft.public.sqlserver.server)
  • Re: Index Defrags
    ... >From BooksOnLine under DBCC INDEXDEFAG: ... DBCC INDEXDEFRAG also compacts the pages of an index, ... the FILLFACTOR specified when the index was created. ...
    (microsoft.public.sqlserver.server)