Home » RDBMS Server » Server Administration » Histogram
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
Previous Topic: Moving p-code of an stored procedure from test server to production server in oracle 8i
Next Topic: Re: Mail me sites for OCP practice exams
Goto Forum:
  


Current Time: Fri Sep 20 14:36:31 CDT 2024