I'm about to start a new series of post about index fragmentation and removing it. For this week's survey, I'd like to know what index maintenance you do to address fragmentation (in any of its forms) – I'll report on it in a week.
Thanks
(The original version of this post first appeared on the now-deleted SentryOne blog at the start of 2022.) One of the most fundamental concepts in
(This post first appeared on SQLperformance.com four years ago as part of a blog series, before that website was mothballed later in 2022 and the
(This is from the Insider Newsletter that I sent out earlier today…) Back in early 2023 I wrote a long blog post about my struggles
This is a case that happened on a client system last year: occasionally a common query on a tiny table appeared to ‘hang’ and had
(TL;DR; Video trailer for the new course is here.) Joe’s next course, AIVSP: Vector Search in Practice, is now available! This online course builds on AIVSE:
(This post first appeared on SQLperformance.com four years ago as part of a blog series, before that website was mothballed later in 2022 and the
With training and consulting from SQLskills, you’ll be able to solve big problems, elevate your team’s capacity, and take control of your data career.
One thought on “Weekly survey: index maintenance plan”
Interesting question! I answered "Complex maintenance based on a list of indexes, fragmentation, or other factors." If you’re interested, the script I use can be found here: http://sqlfool.com/2009/03/automated-index-defrag-script/. If you’ve got time and any inclination, I’d love to hear your thoughts on it, especially if I’m missing anything. :)