EXPLAIN SELECT * FROM `city`;#全文搜索最慢
#范围搜索
EXPLAIN SELECT * FROM `city` where ID>5 and ID<20;
#主键搜索
EXPLAIN SELECT * FROM `city` where ID=5;
#索引搜索
EXPLAIN SELECT * FROM `city` where CountryCode='NLD';
#普通搜索
EXPLAIN SELECT * FROM `city` where Name='Haag';
全文搜索、范围搜索、主键搜索、索引搜索、普通搜索的区别
最新推荐文章于 2024-06-12 11:13:48 发布