Ben Nadel
On User Experience (UX) Design, JavaScript, ColdFusion, Node.js, Life, and Love.
Ben Nadel at CFUNITED 2010 (Landsdown, VA) with: Colleen Lanham and Demian Holmberg and Robert Dix and Paul Carney and Eric Pfleckl
Ben Nadel at CFUNITED 2010 (Landsdown, VA) with: Colleen Lanham , Demian Holmberg@dah007 ) , Robert Dix@p_robert_dix ) , Paul Carney@perpetapaul ) , and Eric Pfleckl@epfleckl )

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 »