Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Full text indexes and hints
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