Exclude re-indexing

RichardGardner

is there any way we can exclude re-indexing operations? We do these weekly and aren't bothered by the changes they generate

Eddie D

Hi, thank you for forum post.

Sadly I am confused by your post. To my knowledge, DLM Dashboard does not create a re-indexing task. Do you have a SQL Agent job or Maintenance Plan performing the re-indexing operation?

RichardGardner

Hi Eddie
Yes we have a maintenance plan that runs every saturday night. As this rebuilds indexes across all our tables we then get a drift in the database schema which I clear on a Monday morning. As this is just maintenance and not (in our eyes) true drift, I wanted to exclude this so a'll im really bothered about is changes to the actual table structure
Rich