Mistraal

mysql> explain SELECT straight_join `doc_pk`, `doc_titulo_es`, `doc_fecha_alta`, `m_museo`.`m_nombre_es`, `cdoc_cat_docum`.`cdoc_nombre_es` FROM `doc_documento`, `m_museo`, `cdoc_cat_docum` WHERE `doc_documento`.`m_pk` = `m_museo`.`m_pk` AND `doc_documento`.`cdoc_pk` = `cdoc_cat_docum`.`cdoc_pk`  ORDER by doc_pk DESC LIMIT 0,10;
+----+-------------+----------------+--------+---------------+---------+---------+-------------------------+------+---------------------------------+
| id | select_type | table          | type   | possible_keys | key     | key_len | ref                     | rows | Extra                           |
+----+-------------+----------------+--------+---------------+---------+---------+-------------------------+------+---------------------------------+
|  1 | SIMPLE      | doc_documento  | ALL    | m_pk,cdoc_pk  | NULL    | NULL | NULL                    |  212 | Using temporary; Using filesort |
|  1 | SIMPLE      | m_museo        | eq_ref | PRIMARY       | PRIMARY | 4    | oamc.doc_documento.m_pk |    1 |                              |
|  1 | SIMPLE      | cdoc_cat_docum | ALL    | PRIMARY       | NULL    | NULL | NULL                    |    4 | Using where                     |
+----+-------------+----------------+--------+---------------+---------+---------+-------------------------+------+---------------------------------+
3 rows in set (0.00 sec)