February 26, 2015 at 3:25 pm
I'm trying to determine a way to do a complex search using full-text indexing. I'm not sure if this is possible. Here's an example:
I have a table with a column that I would like to index, that column contains long phrases. An example phrase is "Please help me with this full-text search question. Thanks.".
What I want to do is when someone searches for something like "full-text help", I would like it to pop up with that record. What it would be doing is on top of searching for the phrase, it would strip out the text into separate words, full-text and help, and then do a search in the column for records that contain that terminology.
Thanks.
February 27, 2015 at 1:20 pm
This should give you an idea
SELECT TicketID
FROM Ticket
WHERE CONTAINS(Description,'Hello World')
I fixed a performance issue I had with description. It was text and had a regular NCI on it. That attribute is used by a ticketing system and the values are very long inputs made by users. Once I deployed a FT on that column and eliminated the previous NCI, the logical reads went down from 3k to about 6 reads average.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply