Oracle 10g users may see improved search and report performance by applying Oracle fix 5765456:7.
For details, see the My Oracle Support (formerly Oracle Metalink) notice "Bug 5040753 Optimal index is not picked on simple query / Column group statistics."
Note: This fix is included in Oracle 10.2.0.4, but it is disabled by default.
|
Copyright © 2014 CA.
All rights reserved.
|
|