Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Help me understand the contents of INDEX_HISTOGRAM please...

Help me understand the contents of INDEX_HISTOGRAM please...

From: Sri <monsri_at_my-deja.com>
Date: 21 Jan 2002 03:52:38 -0800
Message-ID: <6425692a.0201210352.3ff0a7b7@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 - 05:52:38 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US