STORED OUTLINES

posted Feb 3, 2012, 6:25 PM by Sachchida Ojha
A Stored outline stores a set of hints for a query. Those hints will be used every time the query is executed. Using the stored outline increase the possibility that the query will use the same execution path each time.

When you migrate from one database to another, the execution path of your queries may change. This can happen due to following reason.

1. You may have enabled different optimizer features in the different database.

2. The statistics of the tables in the query differ

3. The stats gathering frequency may differ

4. Version of database may be different


The purpose of store outline is to provide plan stability.



 

Comments