Thanks for the example.  The NOT EXISTS query is much faster than what I was trying with NOT IN.

No, I won't be limiting the TicketOpenDate for the query.  I may add a month filter to limit TicketOpenDate at a later time.  The initial query will look at all...