What are stored outlines?
Are you preparing for IT certification? With practice questions, study notes, interactive quizzes, tips and technical articles, uCertify PrepKits ensure that you get a solid grasp of core technical concepts to ace your certification exam in first attempt.
What are stored outlines?
Rating:
Stored outlines are abstractions of execution plans that are created by the Oracle optimizer at the time of creation of the outline. Basically, stored outlines are represented as a set of hints. These hints are used at every subsequent use for compiling the outlines. The stored outlines are stored in the OUTLN schema. Oracle can use public as well as private outlines for SQL statements. Oracle generates an equivalent execution plan from the stored outlines, if the use of the latter is enabled. The plans maintained in stored outlines do not change upon change in computer configuration or statistics even to the extent that changing the optimizer does not affect the execution plans in stored outlines.
Rating:
Was this information helpful?
Other articles
- What is a transaction table?
- What does the PCTFREE parameter specify?
- What is the STATSPACK utility used for?
- What is ALTER SESSION statement?
- What is undo space?