There are several possibilities as to why the query run time improves.

1. The degree of selectivity of the field ContractId is very high. This makes the query inside THEN clause...