------=_NextPart_000_015D_01C35115.AD04EC90
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Hello everyone. I have copied the results from and explain on a query =
that I want to use. And I am wondering if anyone could tell me if these =
results are bad or good?
If everything below is coming up garbled for you I will basically I am =
using 7 tables and the rows for 6 of the seven are 1 and the the seventh =
has 190892916 effected.
+-------+--------+----------------------------------+---------+---------+=
--------------+-----------+---------------------------------------------+=
| table | type | possible_keys | key | key_len =
| ref | rows | Extra =
|
+-------+--------+----------------------------------+---------+---------+=
--------------+-----------+---------------------------------------------+=
| bl | ALL | PRIMARY,receiver | NULL | NULL =
| NULL | 190892916 | where used; Using temporary; Using filesort =
|
| bm | eq_ref | PRIMARY,sender | PRIMARY | 4 =
| bl.id | 1 | =
|
| m | eq_ref | PRIMARY,account_login_last_index | PRIMARY | 15 =
| bl.receiver | 1 | where used =
|
| mi | eq_ref | PRIMARY | PRIMARY | 15 =
| m.nick | 1 | =
|
| be | eq_ref | PRIMARY | PRIMARY | 15 =
| m.nick | 1 | where used; Using index; Not exists =
|
| ms | eq_ref | PRIMARY | PRIMARY | 15 =
| bm.sender | 1 | =
|
| si | eq_ref | PRIMARY | PRIMARY | 15 =
| ms.nick | 1 | =
|
| z | eq_ref | PRIMARY | PRIMARY | 10 =
| m.zip,ms.zip | 1 | =
|
+-------+--------+----------------------------------+---------+---------+=
--------------+-----------+---------------------------------------------+=
------=_NextPart_000_015D_01C35115.AD04EC90--