Re: stored outlines and bind variables
Date: Wed, 3 Feb 2010 08:37:27 -0600
The answer is no (I'm pretty sure). Profiles have a way sharing across multiple statements that use literals (force_matching), but different variable names will be considered different statements.
On Feb 3, 2010, at 8:00 AM, hrishy wrote:
> I have two sql statements like this
> 1)select ename from emp where empno :=b1
> 2)select ename from emp where empno := b2
> if i create a stored outline for the first will oracle use the
> stored outline for the second ?statement ?
> If not can i resort to using profiles can a single profile be used
> in this case for