Full text indexing

[DomTrix]

Damn, I was so pleased I solved my problem, now I have a new obstruction!

How can you make FREETEXT / FREETEXTTABLE search multiple columns in your table when you can only set one column per table for Full text indexing? I thought you could create a new catalog for each column you wanted to index but it only allows one Index per table .

I want to search my Product table for title, description, ISBN, etc.

Thanks for any help,

DT

 

[vongrunt]

One catalog = many full-text indexes.

One index per base table, yes. But...

One index = many columns. In fact, all existing string columns are available.


------
"There's a man... He's bald and wears a short-sleeved shirt, and somehow he's very important to me. I think his name is Homer."
(Jack O'Neill, Stargate)

 

[DomTrix]

Ah cool ty. Then my search just aint working damnit lol.

Is it good practice to put different table FTI's into one catalog? Does it make a difference?

Its just that I am experiencing strange results with FREETEXTTABLE. It ranks the results from 0 - 1000, 1000 being the best match right.

If I have an author field that is 'GREEN MICHAEL' I get a ranking of 92 when I search for '"GREEN MICHAEL"'. Why not 1000? If I do the same search on a title that merely contains '...GREEN MICHAEL...' I get a ranking of 164, my mind boggles!