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


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 »