There are 154 key values that appear exactly once each,
101 key values that appear exactly twice each,
24 key values that appear exactly 3 times each,
and so on.
No key value appears more than 6 times.
--
Jonathan Lewis
http://www.jlcomp.demon.co.uk
Now running 3-day intensive seminars
http://www.jlcomp.demon.co.uk/seminar.html
Host to The Co-Operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html
Author of:
Practical Oracle 8i: Building Efficient Databases
Sri wrote in message <6425692a.0201210352.3ff0a7b7_at_posting.google.com>...
>Hello,
>
>Could you please help me interpret the contents of INDEX_HISTOGRAM
>once I've analyzed an index (I was pretty bad at maths when in
>high school, and much worse in the subject statistics...) ? So if you
>take the following output for ex., what conclusion would you draw
>from the figures this view currently contains ??, what do they mean ?:
>
>REPEAT_COUNT KEYS_WITH_REPEAT_COUNT
>------------ ----------------------
> 0 0
> 1 154
> 2 101
> 3 24
> 4 16
> 5 4
> 6 1
> 7 0
> 8 0
> 9 0
> 10 0
> 11 0
> 12 0
> 13 0
> 14 0
> 15 0
>
>16 rows selected.
>
>Thanks a lot...
>Sri
Received on Mon Jan 21 2002 - 06:09:20 CST
