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
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your
message can get through to the mailing list cleanly
