0

I am working in Spring-java and mysql.

I have to query the table of size 100k records. Table has say 10 columns. And In my sql select query I have to make like queries with %text% search on say 4 columns. Those 4 columns are varchar(200), having average text size of 30 character.

I have gone through few blogs and SO answers to understand about index and after reading I came to this question.

Will making those 4 columns individually FULLTEXT index, makes difference in execution time of like query?

Anthon
  • 69,918
  • 32
  • 186
  • 246
Naman Gala
  • 4,670
  • 1
  • 21
  • 55
  • 1
    no distractions, no chit-chat (read [help→tour](http://stackoverflow.com/tour)), thanks are never part of good question – Anthon Mar 19 '15 at 07:33
  • I got answer for this question over [dba community](http://dba.stackexchange.com/a/95661/58318) – Naman Gala Mar 25 '15 at 10:42

1 Answers1

0

If you have FULLTEXT index, like with some certain char starter will use the index. Eg a like 'hello%'.But when you use a like begin with %, the index wouln't work. You can test it by yourself using explain.

amow
  • 2,203
  • 11
  • 19