Union and distinct

some times you can see statements with union all and distinct. But it's easier and better for performsnce to use union instead of union all and distinct.

15th Nov 2017, 8:07 PM
Alexander Schaubert
Alexander Schaubert - avatar
1 Answer
Hello, Distinct and Union clauses are totally different clauses. If you need a fast return on the query you must use union all. https://stackoverflow.com/questions/35627923/union-versus-select-distinct-and-union-all-performance
27th Dec 2017, 4:49 PM
Kaan Çelik
Kaan Çelik - avatar