13 Feb
10G Optimizer Statistics Gathering
10G Grid Control provides an optimizer statistics administration panel that allows administrators to gather, restore, delete, lock and unlock object statistics. Before we learn how to use 10G Grid Control R2’s object statistics administrations panels, let’s take a quick look at object statistics and find out why they are so important to effective query optimization.
Part 1 of this three part series will provide a high-level overview of optimizer statistics. Part 2 will focus on maintenance windows that control when automatic statistics gathering jobs run. In part 3, we’ll learn how to use 10G Grid Control R2 to ensure that the optimizer has the correct statistical information it needs to generate optimal access paths.