• Glad to hear that the rewrite helped.

    Very much agree with Jeff in that looking at Execution plans and query costs alone can be dangerous especially when changing things bring the cost down and IO up. It's one thing when those data pages are in memory but if you are having to go to disk to get data, that is always going to drastically impact performance. So, less reads with less cost is always nicer. 🙂

    David

    @SQLTentmaker

    “He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot