How Skewness Can Make Your Execution Times Variable

  • Stelios Charalambides


Skewness is one of those topics that for some reason is often ignored, or misunderstood. Skewness is an important part of data handling for the cost-based optimizer. It makes a difference as to what the optimizer decides to do. It is so important that Oracle created new features such as Adaptive Cursor Sharing just to handle the consequences of skewness. Skewness and the types of skewness are so important that in 12c there are more types of histograms to take account of the different ways in which data can be skewed. So understanding skewness is pretty important.


Execution Time Object Type Frequency Histogram Execution Plan Skewed Data 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.

Copyright information

© Stelios Charalambides  2017

Authors and Affiliations

  • Stelios Charalambides
    • 1
  1. 1.New HamptonUSA

Personalised recommendations