Re: Functional Index on Oracle in NT

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: 26 Nov 2001 07:31:28 -0800
Message-ID: <9ttn8g01dt3@drn.newsguy.com>

In article <3c023159$1_at_usenetgateway.com>, yewpc says...
>
>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
>

yes they work in NT

see
http://asktom.oracle.com/~tkyte/article1/index.html

for how to use them.

>
>
>--
>Posted via dBforums
>http://dbforums.com
>

--
Thomas Kyte (tkyte@us.oracle.com)             http://asktom.oracle.com/ 
Expert one on one Oracle, programming techniques and solutions for Oracle.
http://www.amazon.com/exec/obidos/ASIN/1861004826/  
Opinions are mine and do not necessarily reflect those of Oracle Corp

Received on Mon Nov 26 2001 - 09:31:28 CST