Re: Has anyone found a Viable Solution? (YEP)
I don't know if it's the definitive solution, but it worked for me.
Problem: Query stuck on the 'Copying to tmp table' state. After a while, server hangs.
Situation: Very, very old database whose tables involved in that query didn't have any kind of index (primary, unique, etc.)
Solution: Create an index for each table involved in the query.
Subject
Views
Written By
Posted
29944
August 11, 2005 11:25AM
24598
August 12, 2005 09:07AM
19865
August 12, 2005 01:06PM
19511
August 22, 2005 09:46AM
17542
August 24, 2005 03:27PM
13839
August 24, 2005 04:05PM
14600
August 26, 2005 11:02AM
8418
August 26, 2005 11:05AM
7748
August 26, 2005 11:45AM
7599
August 26, 2005 05:46PM
7905
August 26, 2005 10:34PM
7430
August 25, 2005 01:08PM
9437
August 26, 2005 11:07AM
6515
August 27, 2005 09:09AM
6883
August 29, 2005 11:50AM
6786
August 29, 2005 12:04PM
6246
August 29, 2005 12:55PM
6923
August 29, 2005 05:26PM
8327
August 29, 2005 06:34PM
5680
August 29, 2005 08:40PM
7256
August 29, 2005 08:47PM
5435
August 29, 2005 09:00PM
8194
August 30, 2005 10:05AM
5586
August 30, 2005 10:18AM
6027
August 30, 2005 10:20AM
6996
August 29, 2005 08:53PM
6124
August 29, 2005 09:50PM
5760
August 29, 2005 10:01PM
6259
August 30, 2005 08:53AM
5556
August 30, 2005 11:22AM
6056
August 30, 2005 11:33AM
5714
August 30, 2005 11:59AM
25326
August 31, 2005 02:32PM
7519
August 31, 2005 02:49PM
6358
August 31, 2005 02:56PM
8916
August 31, 2005 03:06PM
9404
December 07, 2006 10:30AM
5884
August 31, 2005 03:10PM
8748
August 31, 2005 03:32PM
18706
August 31, 2005 07:15PM
6150
September 01, 2005 03:05AM
8792
September 15, 2005 04:31PM
6621
September 01, 2005 04:39AM
5881
September 08, 2005 09:53AM
5932
September 08, 2005 11:25AM
6670
September 26, 2005 11:52AM
5599
September 26, 2005 12:13PM
5507
September 27, 2005 09:55AM
5550
September 27, 2005 10:18AM
5045
September 28, 2005 10:29AM
5181
September 28, 2005 10:34AM
5532
September 28, 2005 10:52AM
5773
September 28, 2005 10:58AM
13584
September 23, 2005 01:56AM
5878
September 23, 2005 07:11AM
9340
October 05, 2005 04:58AM
7147
October 05, 2005 04:52PM
8201
October 05, 2005 11:49PM
6729
October 06, 2005 01:34AM
9065
October 06, 2005 04:57PM
5745
December 13, 2005 10:28AM
5602
December 13, 2005 10:34AM
5416
November 17, 2005 09:39AM
Re: Has anyone found a Viable Solution? (YEP)
7027
January 08, 2007 12:12PM
5712
December 12, 2005 02:13PM
5735
December 14, 2005 11:43PM
7830
December 15, 2005 08:37AM
5778
December 15, 2005 11:18AM
7986
December 15, 2005 11:27AM
6580
December 15, 2005 11:32AM
5028
December 15, 2005 11:43AM
8006
December 15, 2005 11:43AM
5245
December 15, 2005 11:48AM
5091
December 15, 2005 11:51AM
6383
December 15, 2005 02:14PM
6179
December 15, 2005 02:18PM
5051
December 15, 2005 02:27PM
7814
December 15, 2005 02:43PM
4877
December 15, 2005 08:46AM
5951
January 26, 2006 12:38PM
5064
January 26, 2006 01:48PM
7535
January 26, 2006 01:48PM
4855
January 26, 2006 01:52PM
5068
January 27, 2006 04:46PM
7542
January 29, 2006 11:21AM
8283
January 30, 2006 09:42AM
5721
February 27, 2006 02:17PM
7984
February 27, 2006 02:23PM
5205
March 05, 2006 04:56AM
6006
March 06, 2006 08:09AM
5098
April 05, 2006 01:03PM
6434
September 27, 2006 08:43AM
7191
November 19, 2006 04:42AM
5667
December 14, 2006 05:45PM
5083
February 01, 2007 04:40AM
5920
November 11, 2007 01:24PM
7123
December 20, 2007 10:40AM
7413
January 21, 2008 10:14AM
6802
January 21, 2008 10:53AM
6836
May 19, 2008 09:41AM
7795
February 05, 2008 10:27AM
7021
March 12, 2008 08:37AM
6272
May 19, 2008 03:02AM
6946
November 14, 2008 12:31AM
8061
March 06, 2009 03:36PM