Histogram [message #59084] |
Mon, 27 October 2003 18:59 |
Sujit Sarkar
Messages: 40 Registered: September 2003
|
Member |
|
|
Hi Friends,
I have a problem in Histogram in Oracle 9i Tuning.
I am asking this doubt to any one of Oracle Gurus'.
I have gone through Oracle 9i Documentation for Creating Histogram of Columns which have highly Skewed data.
I understood the usage of histogram.
I could not understand how oracle uses the Histogram for performance enhancement.
Can you make me understand the difference between Height based & Value based Histogram by giving simple examples.How many rows i keeps with buckets? I am totally confused.
I need this help urgently.
Thanx in Advance
Sujit
|
|
|