Is SQL Job Required to Maintain Indexes for TFS databases

The recommendation from the Product Group is to not run a separate index maintenance job as the Optimize Databases TFS job will handle updating of indexes for TFS related databases (Config/Collection DBs). The stored procedure prc_OptimizeDatabase goes through all the indices (including clustered indices) and rebuilds them online if they are more than 20% fragmented….

0