mysql全文索引性能问题

y53ybaqx  于 2021-06-21  发布在  Mysql
关注(0)|答案(0)|浏览(253)

我已经为一列创建了全文索引,如alter表 test1 添加全文索引 organizationname1 ( organizationname asc公司);

When I run this query 
    SELECT * FROM test1 WHERE MATCH(organizationname) AGAINST(' Limited');
    This query tack duration/ Fetch 0.061s/1.6700sec

but I am using like keyword in my  query 

 SELECT * FROM test1 WHERE organizationname like'%Limited%'
 This query tack duration/ Fetch 0.031s/0.071sec

**Now I want to know search performance?**

暂无答案!

目前还没有任何答案,快来回答吧!

相关问题