cats
sunnylovey
xiaohai
iaiyhadlda
jamesalleniwd
shuming
habeb1
addisonjame01
yasmine1101
dellsony
jacobsebastian
toponscom
pinaldave
akkushaus
lapss321
Lenovo13
http://ozziemedessql.blog...
mayluobatty
ashishgilhotra
abcdee
AdaTheDev
lauriesteve
http://ghemant.myopenid.com/
lemontree
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...
|
3
kudos |
|
||||
joewebb
sa
No comments yet, be the first one to post comment.