Gathering Statistics for Cost Based Optimizations

Oracle 11g and later supports only cost-based optimization, which relies on accurate statistics to determine the optimal access path for a query. To gather the appropriate statistics for the optimizer, which will improve database performance, run the ORPM_STATS_GATHER.SQL script located in the \Database\scripts\common folder of the P6 EPPM physical media or download.



Legal Notices
Copyright © 1999, 2016, Oracle and/or its affiliates. All rights reserved.

Last Published Friday, September 30, 2016