RANKMETHOD Term in SharePoint Search SQL Syntax

Last modified: April 21, 2010

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> )

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 Note

If you do not specify a RANKMETHOD, SharePoint Server search uses the default JACCARD COEFFICIENT method.

The following example shows an ISABOUT term that specifies a RANKMETHOD.

…WHERE CONTAINS(Description, 'ISABOUT("computer","software") RANKMETHOD INNER PRODUCT')
Show: