Home Forums SQL Server 2005 Administering MSDB.dbo.sysjobhistory - smart to swap clustered/non clustered indexes? RE: MSDB.dbo.sysjobhistory - smart to swap clustered/non clustered indexes?

  • August 6, 2015 at 9:25 am

    #1817902

    What about indexes on MSDB that are highly fragmented? Like sysjobhistory, index "clust". Do I need to manually reorg or rebuild? I'm not really finding anything on whether or not the syspolicy_purge_history job does the index cleanup?

    Changinagain