Skip to main content
Ben Nadel
On User Experience (UX) Design, JavaScript, ColdFusion, Node.js, Life, and Love.


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 »