XPost: comp.databases.oracle.misc   
   From: no.spam@please.com   
      
   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...   
      
   --   
   ------------------------------------------------------------------------   
      
   *Michael Willer*   
   *Oracle & J2EE architect*   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)