Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Function based index not being used

Re: Function based index not being used

From: Barbara Boehmer <baboehme_at_hotmail.com>
Date: 9 Jul 2005 12:30:33 -0700
Message-ID: <1120937433.211011.273710@g49g2000cwa.googlegroups.com> 





This thread seems to be a duplicate of one in another forum that I have
responded to, in which I also pointed out that when your function that
you are using in the function-based index is returning a raw datatype,
the result must be constrained with substr.  Here is a link to the
other thread:



http://groups-beta.google.com/group/comp.databases.oracle.misc/browse_frm/thread/e029b064039a6ec8/b9d2e2d97399d5a1#b9d2e2d97399d5a1
Received on Sat Jul 09 2005 - 14:30:33 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US