Thank you e4d4. There is no significant blocking when the query is executing. Just the normal SQL Server behavior.

Thank you Jeffrey.

The process is an index maintenance one which reorganizes indices under 10% fragmented and rebuilds 10% or more. In the instance I am talking about it ran a...