Join SQL sleuth Pinal Dave, as he examines two cases where the optimizer is the criminal that killed query performance. Together, we’ll carefully investigate the query optimizer and attempt to understand why it often behaves in a manner beyond common sense. Performance forensics aren’t for the faint of heart; join only if you have a keen desire to solve mysteries and learn advanced concepts of the query optimizer.