Okay, so we all know that problem of SQL-Statements suddenly going AWOL and using a completely different execution plan from what the database has used in the past. Most of the time the database will take the right route by changing the execution plan - but, alas, not always. By using outlines you can force the Oracle database to use the same execution plan regardless of what has changed in the way of statistics or indexes. This entry neatly explains how it works and when you might want to use outlines.
Search
About this Entry
This page contains a single entry by Paul Lewin published on March 26, 2008 3:42 PM.
Redefinition of Oracle tables (online / offline) was the previous entry in this blog.
Running external shell or java Jobs is the next entry in this blog.
Find recent content on the main index or look in the archives to find all content.
Categories
Monthly Archives
- January 2009 (1)
- December 2008 (1)
- November 2008 (1)
- October 2008 (1)
- September 2008 (1)
- July 2008 (1)
- May 2008 (4)
- April 2008 (2)
- March 2008 (2)
- February 2008 (2)
- January 2008 (3)
- December 2007 (2)
- November 2007 (1)
- October 2007 (1)
- September 2007 (1)
- August 2007 (1)
- July 2007 (3)
- February 2007 (2)
- July 2006 (1)
- February 2006 (1)
- September 2005 (5)
- July 2005 (2)
- May 2005 (1)
- January 2005 (1)
- December 2004 (2)
- November 2004 (1)
- October 2004 (1)
- September 2004 (3)
- July 2004 (4)
- June 2004 (5)
- May 2004 (2)
- April 2004 (7)
- March 2004 (7)
- February 2004 (4)
- January 2004 (11)
- December 2003 (3)
- November 2003 (2)