assigning weight to columns with fulltext (is it possible?)

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Pacific Fox - Web Design Brisbane - 13 Dec 2007 09:09 GMT

Hello all,

I have a table which has several fulltext enabled columns.

Title, Summary, Description

I was wondering whether it is possible to assign some kind of weight
to the columns? For example, I find it more relevant if the keywords
are in the title than in the description. Therefore I would like
records that have the matching keywords in the title to come up first.
I'm thinking the way to achieve this is by assigning weight to the
columns, but am not sure how to go about doing this.

Any advice is much appreciated.

Reply to this Message

Pacific Fox - Web Design Brisbane - 13 Dec 2007 09:21 GMT

PS. I did have something going a while ago where I used CONTAINSTABLE
and severals join plus some variables which contained the weight and
used that on the RANK value. Thing was, it was REALLY really slow on
10,000+ records.

On Dec 13, 7:09 pm, Pacific Fox - Web Design Brisbane
<tacofl...@gmail.com> wrote:

> Hello all,
>
[quoted text clipped - 10 lines]
>
> Any advice is much appreciated.

Reply to this Message

Hilary Cotter - 13 Dec 2007 21:30 GMT

Unfortunately the join approach is the only solution to something like this.

Signature

http://www.zetainteractive.com - Shift Happens!

Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com

> PS. I did have something going a while ago where I used CONTAINSTABLE
> and severals join plus some variables which contained the weight and
[quoted text clipped - 17 lines]
>>
>> Any advice is much appreciated.

Reply to this Message