mysql 忽略索引_Mysql索引被忽略了

EXPLAIN SELECT

*

FROM

content_link link

STRAIGHT_JOIN

content

ON

link.content_id = content.id

WHERE

link.content_id = 1

LIMIT 10;

+----+-------------+---------+-------+---------------+------------+---------+-------+------+-------+

| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |

+----+-------------+---------+-------+---------------+------------+---------+-------+------+-------+

| 1 | SIMPLE | link | ref | content_id | content_id | 4 | const | 1 | |

| 1 | SIMPLE | content | const | PRIMARY | PRIMARY | 4 | const | 1 | |

+----+-------------+---------+-------+---------------+------------+---------+-------+------+-------+

但是,当我删除WHERE时,查询将停止使用该键(即使我明确强制它)

EXPLAIN SELECT

*

FROM

content_link link FORCE KEY (content_id)

STRAIGHT_JOIN

content

ON

link.content_id = content.id

LIMIT 10;

+----+-------------+---------+--------+---------------+---------+---------+------------------------+---------+-------------+

| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |

+----+-------------+---------+--------+---------------+---------+---------+------------------------+---------+-------------+

| 1 | SIMPLE | link | index | content_id | PRIMARY | 7 | NULL | 4555299 | Using index |

| 1 | SIMPLE | content | eq_ref | PRIMARY | PRIMARY | 4 | ft_dir.link.content_id | 1 | |

+----+-------------+---------+--------+---------------+---------+---------+------------------------+---------+-------------+

这有什么解决方法吗？

我意识到我在第二个例子中选择了整个表,但是为什么mysql突然决定它会忽略我的FORCE并且不使用密钥？没有密钥,查询需要10分钟……呃.