Re: Enforcing plan via SQL plan baseline
Date: Tue, 7 Feb 2012 07:14:30 +0000
> 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.
Troubleshooting Oracle Performance, Apress 2008 http://top.antognini.chReceived on Tue Feb 07 2012 - 01:14:30 CST