Re: function based index in 9i require query_rewrite_enabled

Hi, where you heard that?, the best you can do is get working the index, as documentation says, and then set the parameter to false and you will see. :)

http://download-west.oracle.com/docs/cd/B10501_01/appdev.920/a96590/adg06idx.htm#7198

Only cost-based optimization can use function-based indexes. Remember to set the QUERY_REWRITE_ENABLED initialization parameter to TRUE, and call DBMS_STATS.GATHER_TABLE_STATISTICS or DBMS_STATS.GATHER_SCHEMA_STATISTICS, for the function-based index to be effective.

On 2/10/06, Jeffrey Beckstrom <JBECKSTROM_at_gcrta.org> wrote:
>
> 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

--
Oracle Certified Profesional 9i 10g
Orace Certified Professional Developer 6i

8 years of experience in Oracle 7,8i,9i,10g and developer 6i
--
http://www.freelists.org/webpage/oracle-l