我已经为一列创建了全文索引,如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?**
暂无答案!
目前还没有任何答案,快来回答吧!