Oracle Histograms Simplified: Part 2
In my previous post Oracle Histograms Simplified: Part 1, I focused on what is histogram & why it is used. In this post I will explain different ways to create & drop histograms. HISTOGRAM CREATION: Creation of histogram is always depends on parameter method_opt that you specify during gathering statistics. […]