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 suggest adding the partitioned column and if so, if the index is constructed aligned, would it be correct to omit such column from the key or the include list since it would be automatically part of it anyway?

Thank you for your time.