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 -> 9i and histogram index

9i and histogram index

From: jabs <no_at_email.com>
Date: Tue, 08 Jul 2003 03:33:39 GMT
Message-ID: <nYqOa.33057$C83.2816401@newsread1.prod.itd.earthlink.net> 





Hi all,



I have a table with 18m rows in a data warehouse. 3 m rows have a '-1' value
and 15 m rows have mostly distinct values. Is this a good candidate for a
histogram index? I searched for info but couldn't find anything useful (a
point in the direction of good documentation of this would be helpful).
TIA,


jabs.
Received on Mon Jul 07 2003 - 22:33:39 CDT












Original text of this message













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