Thank you for the advice. I changed the stats update job to run weekly (took 4 hours with full scan). Our rebuild index process runs daily for less than 10...

Thank you for the info!! really appreciated. We used local variables.

This is what happened in the past few days with the execution plan in Production, it was using this:

Thank you both, Ed B and ScottPletcher! Really appreciated your fast responses. I don't know why the code was using a left join (it was written 15 years ago by...