Skip to main content
Ben Nadel
It's not enough; but, not enough is better than nothing.
Ben Nadel at cf.Objective() 2017 (Washington, D.C.) with: Mallory Woods
Ben Nadel at cf.Objective() 2017 (Washington, D.C.) with: Mallory Woods@THEMalloryWoods )

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 »