Re: Enforcing plan via SQL plan baseline
- From: Christian Antognini <Christian.Antognini@xxxxxxxxxxxx>
- To: amit bansal <amit.bansal82@xxxxxxxxx>, "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 7 Feb 2012 07:14:30 +0000
Hi Amit
> While testing DBMS_SPM I found that if we use alias in query and copy that
> plan to original statement, it will not work.
The hints stored in a SQL plan baseline references the tables via their
aliases. Hence, you cannot use hints generated by a statement with aliases for
a statement without aliases.
HTH
Chris Antognini
Troubleshooting Oracle Performance, Apress 2008
http://top.antognini.ch
--
//www.freelists.org/webpage/oracle-l
Other related posts:
