Re: CONTEXT index and word importance
Date: Fri, 11 Apr 2008 09:30:42 -0700 (PDT)
Message-ID: <b6ec4baf-062e-4969-a56d-3a1cb786d530@l42g2000hsc.googlegroups.com>
On Apr 10, 2:55 pm, "www.douglassdavis.com"
<douglass_da..._at_earthlink.net> wrote:
> I am using a CONTEXT text index with 10g express (to develop with on
> my laptop). I crated a custom search that joins together columns from
> many tables using PL/SQL.
>
> Is there any way to mark some words as relatively more important? For
> example, a match on a title should rank higher than a match on some
> other words in the other text.
>
> The only way I can think of to do this is to make two separate
> indexes, one for the titles, one for the other text, then somehow add
> the two values coming from both CONTAINS clauses together to get the
> relative match.
>
> Any other ideas?
>
> Thanks.
Upgrade to 11g and use the new user-defined scoring capability. See http://download.oracle.com/docs/cd/B28359_01/text.111/b28304/cqoper.htm#CHDIHDAC Received on Fri Apr 11 2008 - 11:30:42 CDT