UNION and data type mismatches Estimated data size as a result of implicit conversions can make a huge difference in the execution plan.