Thank you Jared,

I think you are right. The MIN aggregate makes it not "SARGABLE".

I did try with top 1 ordered desc but had the same plan.

Any tips are welcome

Thanks

Andrea

Hi there,

Just two quick questions.

1) Some indexes reported missing actually exist. Why would that happen?

2) The second one is about partitioned tables. Would it be correct for this query to...