product

The product operator multiplies the score value for the documents for each of the search elements. To arrive at a document’s score, the Enhanced Full-Text Search engine calculates a score for each search element and multiplies the scores. For example:

select t1.score, t2.copy
from i_blurbs t1, blurbs t2
where t1.id=t2.id and t1.score > 50
and t1.index_any = "<product>(cat, created)"

The score value for each search element is 78; however, because the score values for the items are multiplied, the document has a score value of 61 (.78 x.78 =.61(100) = 61).