• You might consider running UPDATE STATS on the object after you've run your INDEXDEFRAG.

    Stats are only updated automatically as part of a REBUILD operation and are not updated when you run INDEXDEFRAG.

    And +1 for moving to the DMVs...(which still runs DBCC SHOWCONTIG behind the scenes, but it's the new way).

    Your friendly High-Tech Janitor... 🙂