Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Help me understand the contents of INDEX_HISTOGRAM please...
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 - 05:52:38 CST
![]() |
![]() |