Using Full Text Indexing

Question

I've a question about the best way to get product data searching by name. Which one is better way to do that?

In brief, can my query be faster if I create a full text index?

score 0 · Accepted Answer · answered Jul 03 '13 at 10:57

0

Are you searching..

answered Jul 03 '13 at 10:57

gbn

I mean, is full text index have any positive affect on normal index ? – Saygın Karahan Jul 03 '13 at 15:17
@SaygınKarahan: no, they are separate and have different operators = vs CONTAINS for example – gbn Jul 03 '13 at 15:26

1 Answers1