Re: Full text indexes and hints

From: Pratap <pratap_fin_at_rediffmail.com>
Date: 12 Sep 2004 22:04:22 -0700
Message-ID: <830861d2.0409122104.5b863349@posting.google.com>

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 Received on Mon Sep 13 2004 - 00:04:22 CDT