Re: Function based index!

Hi,

I think, Oracle 10.2 provides also another solution for your problem: You can do a case-insensitve search..
try to set NLS_COMP to XGERMAN_CI, then 'abc' and 'ABC' are the same...

best regards
Steven

Hans wrote:
> I have several applications which executes SQL statements where the where
> clause sometimes is forced to use upper case.
>
> Select some_field from some_table where some_field='abc'
>
> Select some_field from some_table where upper(some_field)=upper('abc')
>
> (criteria may also be "where some_field like 'abc%'.....")
>
> Questions:
> 1. Since both queries above is execeuted pretty often (of course the search
> condition 'abc' is changed) should I create two indexes on the same column
> (some_field in this case) where one is an upper case index so Oracle always
> can use an index?
> 2. Is function-based index supported in standard edition or only in
> enterprise edition (only have enterprise edition to test on)?
>
> Platform: Windows 2003
> Oracle 10g (10.2)
>
> Regards
> /Hans
Received on Tue Sep 26 2006 - 10:54:24 CDT