Hi, There is no clustered index on the owners table, the oid is a non-unique non-clustered index.

the partitioned tables clustered index is on the appointmentdate, non-unique but the oid is non-unique and non-clustered as well

I did put a clustered index on the owners.oid just as a test and it didnt change anything.

I didnt think the indexes came into play for eliminating?