question

Sudheer avatar image
Sudheer asked

Full Text Index help.........

hi, In my Table has four fields,Three fields mentioned as full text( ItemName,SubTitle,Description(length 4000)) and one primary key. If i give input as string 'Test', i need to search first in Itemname ,If not get the data then will move to subtitle field otherwise will search into Description field. What are they steps to be need to implement the search criteria. In my query it will take so much time Ex Select IT.ItemName from dbo.Wdl_Item IT Where IT.MainCategoryId = 1 And (((@InKeywords = '""') OR CONTAINS(it.ItemName, @InKeywords)) OR ((@InKeywords = '""') OR CONTAINS(gi.subtitle, @InKeywords)) OR ((@InKeywords = '""') OR CONTAINS(gi.[description], @InKeywords))) Thanks in advance............
sql server
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

0 Answers

·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.