joewebb

joewebb
Name: joewebb
Score: 42
Last Seen: 1020 days, 18 hours, 6 minutes ago
Member Since: 27 July, 2009
SqlServerKudos
atom rss
3
kudos
spam Kudos Remove

The effects UNION in a SQL query « WebbTech Solutions
published 1013 days, 16 hours, 37 minutes ago posted by joewebbjoewebb 1020 days, 18 hours, 58 minutes ago
Thursday, August 13, 2009 4:13:26 PM GMT Thursday, August 06, 2009 1:52:30 PM GMT
The effects UNION in a SQL query « WebbTech Solutions
In a recent blog, I shared some of the natural but sometimes unanticipated consequences of adding DISTINCT to a SELECT statement. Adding DISTINCT ensures that you don’t have duplicated rows in your result set, but that assurance comes at a price. Performance is typically impacted negatively when you add DISTINCT to a query. You can read the blog and see the proof here. But there is another operator that can have some not-so-obvious side affects. Let’s a have look how UNION can affect a query’s performan... (more)
category: Query | clicked: 4 | comment | | source: webbtechsolutions.com