• The process is making pretty good use of indexes. It is only seeks and it's a seek on the nonclus index on ID for the TD table. I will try to attach the query plan.

    The ratio is about 2 TD rows to 1 T row.