stored outlines and bind variables

  • From: hrishy <hrishys@xxxxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Wed, 3 Feb 2010 14:00:16 +0000 (GMT)

Hi
 
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 
 
regards


      

Other related posts: