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: performance problems on new function-based index

Re: performance problems on new function-based index

From: sybrandb <sybrandb_at_gmail.com>
Date: 4 Aug 2006 02:48:52 -0700
Message-ID: <1154684932.155793.39810@b28g2000cwb.googlegroups.com> 






Guitarator wrote:


> Hi

>

> I must precise that if you're under Enterprise Edition you must set

> query_rewrite_enabled to true.

>

> regards

> Denis




He is working with 10g, as he has case insensitive sort.
In 10g, IIRC, query_rewrite_enabled is no longer necessary.
Also in 9i Standard function based indexes are available.
Please try to be really precise.


-- 
Sybrand Bakker
Senior Oracle DBA


Received on Fri Aug 04 2006 - 04:48:52 CDT












Original text of this message













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