Competition: What’s your favorite Redgate tool? Enter now.

Exclude re-indexing

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

Comments

  • Eddie DEddie D Posts: 1,688 Rose Gold 5
    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?
    Eddie Davis
    Product Support Engineer
    Redgate Software Ltd
    Email: [email protected]
  • 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
Sign In or Register to comment.