Re: Oracle 8.0 - Can't use function index

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.

-- 
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)