It may have to do with the query plan being cached on the first run and reused, even though it's non-optimal for the particular data. See: "How SQL Server Chooses...