Community Member Profile
Akansha
Member since Aug 3, 2010
- Profile: /members/6569-Akansha.htm
- Comments: 1
- Points: 11
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... read more »
