Re: stored outlines and bind variables

From: hrishy <hrishys_at_yahoo.co.uk>
Date: Wed, 3 Feb 2010 14:53:49 +0000 (GMT)
Message-ID: <222288.69578.qm_at_web29020.mail.ird.yahoo.com>

Hi Kerry
 

Thanks for the answer.
 

I was being lazy and was just trying a short cut to create a profile and take care of all statements like
 

select ename from emp where empno :=b1
select ename from emp where empno :=b2
 

with one sql profile/outline i guess profiles or outlines are not a substitute to generating good plans with statistics.
 

regards
 

• On Wed, 3/2/10, Kerry Osborne <kerry.osborne_at_enkitec.com> wrote:

From: Kerry Osborne <kerry.osborne_at_enkitec.com> Subject: Re: stored outlines and bind variables To: hrishys_at_yahoo.co.uk
Cc: oracle-l_at_freelists.org
Date: Wednesday, 3 February, 2010, 14:37

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.

Kerry Osborne
Enkitec
blog: kerryosborne.oracle-guy.com

On Feb 3, 2010, at 8:00 AM, hrishy wrote:

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

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Feb 03 2010 - 08:53:49 CST