plan as the production has and would demonstrate that the second query performs better. 작은 데이터 집합에 대한 계획을 분석하는 것은 재미있기는 하지만 매우 무익한 작업입니다. Now my problem with the union all vs the left outer join, is really first of all performance, and also the maintenance of the query.