Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Bind Variable Substitution In Exec Plan

Re: Bind Variable Substitution In Exec Plan

From: <poddar007_at_gmail.com>
Date: 17 Nov 2005 15:44:45 -0800
Message-ID: <1132271085.407247.110100@g49g2000cwa.googlegroups.com>


This is a transitive closure used by the optimizer where a=3 and a=b implies b=3.

This can be turned of by query_rewrite_enabled=false

amit Received on Thu Nov 17 2005 - 17:44:45 CST

Original text of this message

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