The product operator multiplies the score value for the documents for each of the search elements. To arrive at a document’s score, the 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).
