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 indexes

function based indexes

From: Harvinder Singh <Harvinder.Singh_at_MetraTech.com>
Date: Tue, 10 Aug 2004 13:19:43 -0400
Message-ID: <D6424CD4C8A3C044BBC49877ED51C5187D92C9@ex2003.metratech.com>


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_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
Received on Tue Aug 10 2004 - 12:15:34 CDT

Original text of this message

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