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 | | +-------+--------+----------------------------------+---------+---------+--------------+-----------+---------------------------------------------+
