Arrangement of multiple tables in UNION

Viewed 252

Will the following three queries differ in performance? I think the first query is efficient. Though behind the scenes , probably the optimizer will anyways make them equivalent.

t1 | union t2,t3,t4    

t1 | union t2 | union t3 | union t4

union t1,t2,t3,t4    
1 Answers

All 3 queries will perform exactly the same, as the query plan of all of them is identical.

Related