Ashish Karalkar wrote:> query which was taking seconds on the join of these two table> suddenly started taking 20/25 min
Show the EXPLAIN ANALYSE of your problem query and someone will be able to tell you why.
-- Richard Huxton Archonet Ltd