为什么我会打扰使用全文搜索？ [英] Why I would bother using full text search?

问题描述

我是全文搜索的新手，我使用了以下查询：

 选择*来自学生FullName LIKE'％abc ％'
  

学生表包含所有随机数百万条记录，看起来像这样
'QZAQHIEK VABCNLRM KFFZJYUU '

仅用了2秒钟就完成了1100行。 如果在两秒钟内搜索到百万条记录，为什么我会打扰使用全文搜索？ Like谓词是否也使用全文索引？

至少你自己满意。如果您的原型能够在可接受的时间内产生结果，并且您确定缓存不能解释快速响应（按照Paul Sasik），那么通过所有方法可以跳过全文索引的开销并继续使用LIKE。

I am new to Full Text Search, I used the following query

Select * From Students Where FullName LIKE '%abc%'

Students table contains million records all random and look like this 'QZAQHIEK VABCNLRM KFFZJYUU'

It took only 2 seconds and resulted 1100 rows. If million record is searched in two seconds why I would bother using Full Text Search ?!! Did Like predicate used the Full Text Index as well?

解决方案

I think you have answered your own question, at least to your own satisfaction. If your prototyping produces results in an acceptable amount of time, and you are certain that caching does not explain the quick response (per Paul Sasik), by all means skip the overhead of full-text indexing and proceed with LIKE.

这篇关于为什么我会打扰使用全文搜索？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！