By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,835 Members | 1,391 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,835 IT Pros & Developers. It's quick & easy.

EXPLAIN - Question..

P: n/a
------=_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--

Jul 19 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.