Ben Nadel
On User Experience (UX) Design, JavaScript, ColdFusion, Node.js, Life, and Love.
Ben Nadel at cf.Objective() 2013 (Bloomington, MN) with: Ben Koshy and Ben Arledge
Ben Nadel at cf.Objective() 2013 (Bloomington, MN) with: Ben Koshy ( @animexcom ) and Ben Arledge@BenArledge )

Benjamin Lotter

Member since Jul 20, 2010

Recent Blog Comments By Benjamin Lotter

  • SQL Optimization And ON Clause vs WHERE Clause

    Posted on Jul 20, 2010 at 3:58 PM

    Recently I took a query running 7 minutes down to 2 minutes by moving filter items in the WHERE clause to their corresponding ON clauses. In my case, there are 6 inner joins with 2 of them being to derived tables. Personally I prefer to keep JOIN logic in the ON clause and filter logic the WHERE c... read more »