s/columns if
you can't let them be seen. :-) Hint: use \G instead of ; at the end of
the EXPLAIN query to make the output more legible.
Matt
- Original Message -
From: "Kevin Fries"
Sent: Friday, September 05, 2003 11:09 AM
Subject: RE: Query hung up in "Copying to tm
in
> -Original Message-
> From: Matt W [mailto:[EMAIL PROTECTED]
> Sent: Thursday, September 04, 2003 1:37 PM
> To: [EMAIL PROTECTED]
> Subject: Re: Query hung up in "Copying to tmp table"
>
>
> Hi Kevin,
>
> I imagine the query is examini
Hi Kevin,
I imagine the query is examining/returning so many rows that it's going
to take a long time to create the needed temporary table (how long have
you it go?). To start with, show us the EXPLAIN output for the problem
SELECT, along with the SELECT. Also the size of the involved tables
(rows
