Long Parses and SQL Plan Baselines

Few days ago, in the post entitled Long Parses, I pointed out that stored outlines can be used to shorten the parse time by restricting the number of execution plans considered by the query optimizer. As of Oracle Database 11g, stored outlines are deprecated in favor of SQL plan baselines. Therefore, someone might think [...]

Lesen Sie den vollständigen Eintrag unter http://antognini.ch/2008/09/long-parses-and-sql-plan-baselines/