Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

Reg SPPS Web DAV Queries

  Asked By: Meera    Date: Dec 21    Category: Sharepoint    Views: 735

in web dav queries there are two predicates for
full text search,
1. CONTAINS predicate
2. FREETEXT predicate.

Can any one of you tell me which one is used for
what purpose.

I have read the SPPS documentation and found that
CONTAINS can be used for exact matches and FREETEXT searches in all the columns.
But i need to know which
one is better or more optimized.



2 Answers Found

Answer #1    Answered By: Latrice Henson     Answered On: Dec 21

Depends what you want to do. The default query for the search web  part
primarily uses freetext. This will give you a broader result set.
Freetext will use stemming and thesaurus. If you search  for run, it will
look for run, ran running ect and any words in the thesaurus that
matches these. If you use a phrase as a search term freetext will look
for each individual word as well as any combos of the words in the
phrase. I believe where freetext looks (in all col) depends on where
you tell it to look, it does not have to be all cols. Contains is a more
exacting It will not stem or use thesaurus. It will not look for
combinations of the words in phrases.

Generally use freetext if you want to get a larger (less specific )
resultset. Use contains if you want to exactly match.

Answer #2    Answered By: Nidhi Tiwary     Answered On: Dec 21


The CONTAINS predicate is better suited for "exact matches,"
in contrast to the FREETEXT predicate, which is better suited
to finding documents containing combinations of the search
words spread throughout the column.

Didn't find what you were looking for? Find more on Reg SPPS Web DAV Queries Or get search suggestion and latest updates.