Have you set query_rewrite=trusted in the init.ora file? Try that.
Jim
"yewpc" <member_at_dbforums.com> wrote in message
news:3c023159$1_at_usenetgateway.com...
> Hi , Does anyone has any ideas on function index on Oracle running
> in NT ? I have created one function index on my database but it is
> not working. My query still not make use of the index to scan. My
> Oracle version is Oracle 8.1.7. Is there anything i need to set to
> make it work ?
>
> Thank you
>
>
>
> --
> Posted via dBforums
> http://dbforums.com
>
Received on Mon Nov 26 2001 - 09:07:28 CST
