Re: Oracle 8.0 - Can't use function index

On Fri, 19 Sep 2003 22:07:28 GMT, jcwhui <j_c_w_h_u_i_at_hot_mail.company> 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

I'm not sure whether you posted any *valid* concerns above

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Fri Sep 19 2003 - 17:37:56 CDT