SQL Profiles are the new generation of outlines. A stored outline essentially creates a frozen query plan for a specific literal version of a query, where that stored optimized query plan is based on the sate of statistics at the time of storing the stored outline. I have found that stored outlines are useful in …