tigertoolbox icon indicating copy to clipboard operation
tigertoolbox copied to clipboard

msdb indexes

Open buckeye0524 opened this issue 7 years ago • 1 comments

Suggestion: Include an option to allow rebuild/reorg of system-generated table indexes, specifically those in msdb. The "WHERE mst.is_ms_shipped = 0" clause used throughout the code prevents this.

buckeye0524 avatar Aug 15 '18 15:08 buckeye0524

System tables should be included, an option is not required. Fragmentation can occur in msdb dbo.sysjobhistory for example.

AndrewG2 avatar Aug 12 '19 07:08 AndrewG2