Re: Oracle 8.0 - Can't use function index

From: Daniel Morgan <damorgan_at_x.washington.edu>
Date: Wed, 24 Sep 2003 16:12:58 -0700
Message-ID: <1064445172.58492_at_yasure>


Michael Willer wrote:

> Daniel Morgan wrote:
>
>> Michael Willer wrote:
>>
>>> jcwhui wrote:
>>>
>>>> I am building an application that accesses to a customer provided
>>>> Oracle. I was assuming function-based indices in Oracle 8.0+, but
>>>> I am wrong. It is only avail since 8i.
>>>> For now, I can only think of introducing another field that stored
>>>> the result of my function, and then I create an index on it. I
>>>> prefer not to because: (1) it introduces another field (in fact, I
>>>> have a few function-based indices)
>>>> (2) my C/C++ code that access it will have to be modified
>>>> (3) because of the above, it will be a waste if I move to another
>>>> customer who uses Oracle 8i+
>>>>
>>>> I just want to see ideas from different people: how do you work
>>>> around this?
>>>>
>>>> Thanks
>>>>
>>>> - Will
>>>>
>>>>
>>> Introduce a new field to hold the derived value.
>>> Create trigger on insert, update to calculate the value.
>>> Create index on the derived column.
>>>
>> The best idea is to upgrade to a version of Oracle that has been
>> supported in the current millenium.
>>
> True. But sometimes a client doesn't want to upgrade. At least right
> now. For example in a 24x7 environment...
>
Then they can't have what they want can they? ;-) Or at least not without the expense of reinventing the wheel.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)
Received on Thu Sep 25 2003 - 01:12:58 CEST

Original text of this message