• Great article!

    This is definitely one of those instances where the journey is more valuable than the destination (for me, at least).

    The methodical testing of the issue and possible solutions led to a counter-intuitive, situation-specific solution. So while the end result [OPTION (FORCE ORDER)] is not a good takeaway, more knowledge and understanding of the value of a systemic query tuning process (the journey) is something I definitely benefitted from.

    Thanks!