> FTI is not used in joins - it is only used with CONTAINS, CONTAINSTABLE,
> FREETEXT, and FREETEXTTABLE in the WHERE.

> Hi everyone,
>
> Got a question for you. Which would be faster:
>
> a. Joining 2 separate tables each with a full text index on the
> applicable fields
>
> or
>
> b. Joining 2 separate tables - 1 of which has a FTI on the applicable
> field and the other table has a non-clustered index on the applicable
> fields
>
> Any commensts/suggestions much appreciated.
> Al.

<almurph@altavista.com> wrote in message
news:1149171407.423993.128810@u72g2000cwu.googlegroups.com...
>> FTI is not used in joins - it is only used with CONTAINS, CONTAINSTABLE,
>> FREETEXT, and FREETEXTTABLE in the WHERE.
>
> Dan - you can use FTI & a join. I know because I have just done so. I
> have a funny feeling that we are on slightly different
>
>
> Example of what I am talking about:
>
> SELECT *
> FROM tableNameA as A
> INNER JOIN tableNameB as B on A.primary_key = B.primary_key
> WHERE CONTIANS(A.ftiFieldName,'"search term A"') and B.name = 'search
> term b'
>
>
> Cheers,
> Al.
>

> Its can be used in joins if you use containtstable, but what Dan means is
> that the key info returned is what the join is done on. The Full-Text
> index does not participate directly in the join.