Re: function based indexes

On Tue, 10 Aug 2004 13:19:43 -0400, Harvinder Singh <harvinder.singh_at_metratech.com> wrote:
> 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

I believe that this restriction was relaxed in 9.2, when the ability to use FBI miraculously appeared in SE where query rewrite is unavailable.

I'd set this parameter based upon your query rewrite needs (say for DW) rather than FBI.

-- 
Niall Litchfield
Oracle DBA
http://www.niall.litchfield.dial.pipex.com
----------------------------------------------------------------
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
-----------------------------------------------------------------