Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Oracle 8.0 - Can't use function index
Two possible options:
HTH Guang
jcwhui <j_c_w_h_u_i_at_hot_mail.company> wrote in message news:<Xns93FB99DA8C27Djcwhui_at_198.80.55.250>...
> 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
Received on Sat Sep 20 2003 - 07:12:05 CDT
![]() |
![]() |