Ben Nadel
On User Experience (UX) Design, JavaScript, ColdFusion, Node.js, Life, and Love.
I am the chief technical officer at InVision App, Inc - a prototyping and collaboration platform for designers, built by designers. I also rock out in JavaScript and ColdFusion 24x7.
Meanwhile on Twitter
Loading latest tweet...
Ben Nadel at cf.Objective() 2014 (Bloomington, MN) with: Jeff McDowell and Jonathan Dowdle and Joel Hill and Josh Siok and Christian Ready and Steve 'Cutter' Blades and Matt Vickers

Akansha

Member since Aug 3, 2010

Recent Blog Comments By Akansha

  • SQL Optimization And ON Clause vs WHERE Clause

    Posted on Aug 3, 2010 at 4:56 AM

    Its taking couple of hours to execute the below query. Both tables have millions of entries and index is on col1, col3 and col4 of tableB. What can I do to make it run fast? update tableA,tableB set tableA.col2 = 1 where tableA.col1 = tableB.col1 and (tableA.col3 < 100 or tableA.col4 >200);... read more »