title: phpMyAdmin hangs while executing known good query (local WAMP server)
body: <p>I'm trying to run the following query from phpMyAdmin (on a local WAMP server):</p>
  <pre><code>SELECT  table2.AreaName, table2.Dialcode
  FROM    table2
  LEFT JOIN
  master
  ON      master.Dialcode = table2.Dialcode
  WHERE   master.Dialcode IS NULL
  </code></pre>
  <p>I first tried on two tables with 4 entries in each and I got a result.</p>
  <p>Now I'm trying (the same query) on my &quot;real&quot; tables with around 20000 entries each and I click on GO. During 5-6 seconds I have &quot;Loading3 appearing in the middle but then nothing happen, no result, anything loading...</p>
  <p>Any idea?</p>
  <p>EDIT:</p>
  <blockquote>
  <p>SHOW INDEXES FROM MASTER</p>
  <p>Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type</p>
  <p>master 1 Dialcode 1 Dialcode A 18731 NULL NULL YES BTREE</p>
  </blockquote>
  <p>And the same thing for the table2.
  I already created indexes of the tables on DialCode by clicking on the INDEX button in PhpMyadmin.</p>
  <p>SOLUTION: Actually the query works fast, that's the treatment I do after which takes time.</p>