Forum Stats

  • 3,758,132 Users
  • 2,251,340 Discussions
  • 7,870,052 Comments

Discussions

Bad Execution plan on the weekends

Hi, I have a SQL that runs in 7 mins on weekdays(M-F) and takes 6 hours on the weekends. I can see that it's using a different execution plan on the weekends and the next Monday and it's back to normal!

I don't have any conflicting processes running on the weekends. I don't know why it's using the bad plan on the weekend. Any idea what's happening here?

Tagged:

Answers