The crucial process to optimize operation is gathering statistics in oracle database. Huỳnh Vương has a nice and brief summary from his *GIF* picture:
(1) Purpose of Statistics
(2) Commands Used
(3) Automatic Statistics Gathering
(4) Manual Statistics Gathering
(5) Using Histograms
(6) Gathering Frequency
(7) Example Command
Basd on his gif I've generated the funny video that coalesces the special effect "dripping light rain", opening-up show "water ripple" & ringing down the curtain "water ripple" and light music "Sometiems When It Rains".
#Database #Oracle #Optimize #GatheringStatistics #PLSQL
