Note:
This topic has been translated from a Chinese forum by GPT and might contain errors.Original topic: TiDB查询使用limit,会有优化效果吗,发现使用limit之后,还是扫描了非常多的key

[TiDB Usage Environment] Production Environment / Testing / Poc
[TiDB Version] v4.0.10
[Reproduction Path] What operations were performed that caused the issue
[Encountered Issue: Issue Phenomenon and Impact]
[Resource Configuration] Go to TiDB Dashboard - Cluster Info - Hosts and take a screenshot of this page
[Attachment: Screenshot/Logs/Monitoring]
The SQL has an index, and the execution plan also uses the index.