SQLTeam.com | Weblogs | Forums

Reorg vs. rebuild indexes in a job or subplan task


#1

Hi Everyone,

I know this is an old topic, but I used to have access to a script that made this decision for me based on some parameters and I'd put a call to it either in a job or subplan task.
I did loosing the drive were I had the code/script (external USB), now I just wonder if anyone out there has come up with the same approach or a better one I could make use of?

Thanks in advance for any replies...!

lec


#2

https://ola.hallengren.com/sql-server-index-and-statistics-maintenance.html


#3

Even better than Ola (in fact, much, much better IMHO): Minion ReIndex


#4

Thank you guys (Tara and GBritton) I will be checking this solutions shortly since they are more involved than what I had in mind (probably wasn't as good yours!)

Thanks again,
lec