• Intersting...

    From what I have seen sometimes (yet rare) calling out the actual index has had a marked improvement on the execution time.

    But except for your "dirty read" comment (which is new knowledge to me..thank you) NOLOCK has been one of the things that I would do to a query, especially one with multiple joins, that would always show a decrease in the overall processing time.

    Thanks for the eye opener however.