Ben Nadel
On User Experience (UX) Design, JavaScript, ColdFusion, Node.js, Life, and Love.
Ben Nadel at BFusion / BFLEX 2009 (Bloomington, Indiana) with: Dee Sadler
Ben Nadel at BFusion / BFLEX 2009 (Bloomington, Indiana) with: Dee Sadler@DeeSadler )

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 »