sql server (alternate): Full-Text Search Query Question - Performance -- sql server (alternate)

Full-Text Search Query Question - Performance

jimdandy NO[at]SPAM shaw.ca
5/27/2004 11:24:33 AM

sql server (alternate):

I have a table with 3M rows that contains a varchar(2000) field with
various keywords. Here is the table structure:

PKColumn
ImageID
FullTextColumn

There is an association table:
ImageID
ContractID

Now, I want to do a query where the ContractID = x and Contains some
word in the FullTextColumn. There is an association table that maps
Images to Contracts - so I can't use the trick of putting the Contract
code in the FullTextColumn.

I'm finding that first the FTS service is performing a search on the
Keyword (which can take a long time if 100K rows are returned) then
joining to the association table for the particular contract.

Is there anyway to make this faster by telling the FTS service, only
search this subset of rows for the keyword based on the contract.

Sorry if this sounds convoluted. Appreciate any help you can suggest.

Re: Full-Text Search Query Question - Performance

sql NO[at]SPAM hayes.ch
5/28/2004 1:14:58 AM

[quoted text, click to view]

You might want to post this in microsoft.public.sqlserver.fulltext to
see if you get a better reply.