Ben Nadel
On User Experience (UX) Design, JavaScript, ColdFusion, Node.js, Life, and Love.
Ben Nadel at the New York ColdFusion User Group (Jan. 2008) with: Clark Valberg and Adam Lehman and Javier Julio
Ben Nadel at the New York ColdFusion User Group (Jan. 2008) with: Clark Valberg@clarkvalberg ) , Adam Lehman@adrocknaphobia ) , and Javier Julio

Drew

Member since May 21, 2010

Recent Blog Comments By Drew

  • SQL Optimization Case Study - JOIN Clause vs. IN Clause

    Posted on May 21, 2010 at 1:32 PM

    IN vs. EXISTS performance can vary depending on the size and indexing of both the outer and inner tables. Also a neat behavior of EXISTS is that it only needs to find one row that matches then it can stop looking. For example, this will return a 0 or 1 (in Oracle - good "row_exists" function): se... read more »