From: Hank
Date: December 21 2005 2:39pm
Subject: Re: Do I need to tweak my server variables for this SELECT statement?
List-Archive: http://lists.mysql.com/mysql/193101
Message-Id: <1990a96b0512210639x1f913090nc836e596030590f6@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

Grant,

  You can just to a "desc pn_pricecompare_catprod" and "desc
pn_pricecompare_product" and post the results.  The CREATE TABLE
statements would be OK, but the describes are better.

The flush the query cache, I think if you do a "flush tables".

-Hank