Home Forums Article Discussions Article Discussions by Author Discuss Content Posted by Amin Sobati The Pitfall of "Not Equal To" Operator in Queries! RE: The Pitfall of "Not Equal To" Operator in Queries!
Ian Griffiths
Ten Centuries
Points: 1025
More actions
August 24, 2006 at 2:18 am
#656509
DISTINCT is definitely a bad idea, performance-wise. Avoid if at all possible as it usually involves having to sort the result set and then scan through it, making lots of unnecessary overhead that can often be avoided.