Re: stored outlines and bind variables
- From: hrishy <hrishys@xxxxxxxxxxx>
- To: kerry.osborne@xxxxxxxxxxx
- Date: Wed, 3 Feb 2010 14:53:49 +0000 (GMT)
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@xxxxxxxxxxx> wrote:
From: Kerry Osborne <kerry.osborne@xxxxxxxxxxx>
Subject: Re: stored outlines and bind variables
To: hrishys@xxxxxxxxxxx
Cc: oracle-l@xxxxxxxxxxxxx
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
Other related posts:
