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

Home -> Community -> Mailing Lists -> Oracle-L -> function based index in 9i require query_rewrite_enabled

function based index in 9i require query_rewrite_enabled

From: Jeffrey Beckstrom <JBECKSTROM_at_gcrta.org>
Date: Fri, 10 Feb 2006 11:44:38 -0500
Message-Id: <s3ec7cb8.072@gcrta.org>


I am looking at setting up a function based index. From the docs it states must set query_rewrite_enabled to true in order to use the index.  I had thought that setting this parameter was not required for 9i.      

Jeffrey Beckstrom
Database Administrator
Greater Cleveland Regional Transit Authority 1240 W. 6th Street
Cleveland, Ohio 44113

--
http://www.freelists.org/webpage/oracle-l
Received on Fri Feb 10 2006 - 10:44:38 CST

Original text of this message

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