Re: Best scenario for FREETEXTTABLE
- From: "nospam@xxxxxxxxxx" <stoumann@xxxxxxxxx>
- Date: Mon, 19 May 2008 00:45:35 -0700 (PDT)
Matijah wrote:
You can create an indexed view referencing both tables (without the
UDF) and
create a full-text index on the view rather than the tables.
Thanks for your reply. The above solution will provide double unique
id's for the books that have more than one author. I tried to create a
combined unique identity with the keys from both the books and the
authors-table, but wasn't allowed to full-text-index it.
Best,
Mazzo
.
- Follow-Ups:
- Re: Best scenario for FREETEXTTABLE
- From: ML
- Re: Best scenario for FREETEXTTABLE
- References:
- Best scenario for FREETEXTTABLE
- From: nospam@xxxxxxxxxx
- Best scenario for FREETEXTTABLE
- Prev by Date: Best scenario for FREETEXTTABLE
- Next by Date: Re: Best scenario for FREETEXTTABLE
- Previous by thread: Best scenario for FREETEXTTABLE
- Next by thread: Re: Best scenario for FREETEXTTABLE
- Index(es):
Relevant Pages
|