Thanks for you comments.

I have tested with MaxDOP=1, and it makes no difference.

However, I did find that by selecting the TOP 100K records, it actually generated the plan without the...