need a script to find indexes which are having more than 30% and do the rebuild index...

Question

Hi All,

i need a script to do the rebuild index based up the fragmentation which are having more than 30%...

Thanks,

---

rup

Answer 1

Take a look at this blog post

http://sqlfool.com/2011/06/index-defrag-script-v4-1/

---

For every expert, there is an equal and opposite expert. - Becker's Law


My blog

Answer 2

Hi Naomi,

Thanks for giving good one...i need to run this one on test environment..

Thanks,

---

rup

Answer 3

I highly recommend using Hallegren's maintenance scripts:

http://ola.hallengren.com/