function based indexes

  • From: "Harvinder Singh" <Harvinder.Singh@xxxxxxxxxxxxx>
  • To: <oracle-l@xxxxxxxxxxxxx>
  • Date: Tue, 10 Aug 2004 13:19:43 -0400

Hi,

We are creating function based indexes and have question about parameter
query_rewrite_integrity. Docs says value for this parameter should be
trusted to be able to use FBT but even when I set this parameter setting
to ENFORCED, optimizer is able to use index. So what should be the value
of this parameter to be able to use function based indexes?
We are using 10g on red hat linux

Thanks
--Harvinder


----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Other related posts: