RANKMETHOD Term in SharePoint Search SQL Syntax
Applies to: SharePoint Server 2010
Used to specify which statistical algorithm to use to rank the documents that match one or more of the ISABOUT match terms. Following is the syntax of the ISABOUT term when using RANKMETHOD.
ISABOUT ( <match_terms> RANKMETHOD <rank_method> )
Remarks
The following table describes the available rank methods.
Rank Method |
Description |
---|---|
JACCARD COEFFICIENT |
Calculates ranking results from the relative proportion of matching terms, excluding any terms that are not matched. |
DICE COEFFICIENT |
Calculates ranking results from the frequency of multiple terms found together, compared with the probability that they are found in isolation. |
INNER PRODUCT |
Calculates ranking results by using the integral of the products of the ranks of the individual matching documents. |
MINIMUM |
Calculates ranking results from the lowest rank score from all the matching documents. |
MAXIMUM |
Calculates ranking results from the highest rank score from all the matching documents. |
Note
If you do not specify a RANKMETHOD, SharePoint Server search uses the default JACCARD COEFFICIENT method.
Examples
The following example shows an ISABOUT term that specifies a RANKMETHOD.
…WHERE CONTAINS(Description, 'ISABOUT("computer","software") RANKMETHOD INNER PRODUCT')