Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Full text indexes and hints

Re: Full text indexes and hints

From: Daniel Morgan <damorgan_at_x.washington.edu>
Date: Sun, 12 Sep 2004 23:14:15 -0700
Message-ID: <1095056120.924513@yasure>


Pratap wrote:

> This approach can also help you -
>
> Have two columns -
> 1. mixed_case - Get the data here as it is
> 2. all_upper_case - Copy the same data from column mixed_case, but
> make it all upper case
>
> Use multi-column datastore to create a *single* index on these two
> columns. Make this index case sensitive. See the Oracle docs for
> details on how to do this.
>
>
> Then you can query -
>
> where contains ( mixed_case, '{SomeThing} within {mixed_case} and
> {SOME_THING_ELSE} within {all_upper_case}' ) > 0
>
> This approach will be much more fater than 2 indexes approach.
>
> Regards,
>
> Pratap

Or go one step further ... build a user-defined data type complete with appropriate methods.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)
Received on Mon Sep 13 2004 - 01:14:15 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US