Path: newssvr20.news.prodigy.com!newsmst01.news.prodigy.com!prodigy.com!logbridge.uoregon.edu!newshub.sdsu.edu!elnk-pas-nf2!newsfeed.earthlink.net!stamper.news.pas.earthlink.net!newsread1.prod.itd.earthlink.net.POSTED!not-for-mail
Reply-To: "jabs" <no@email.com>
From: "jabs" <no@email.com>
Newsgroups: comp.databases.oracle.misc
Subject: 9i and histogram index
Lines: 11
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1106
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106
Message-ID: <nYqOa.33057$C83.2816401@newsread1.prod.itd.earthlink.net>
Date: Tue, 08 Jul 2003 03:33:39 GMT
NNTP-Posting-Host: 69.3.125.195
X-Complaints-To: abuse@earthlink.net
X-Trace: newsread1.prod.itd.earthlink.net 1057635219 69.3.125.195 (Mon, 07 Jul 2003 20:33:39 PDT)
NNTP-Posting-Date: Mon, 07 Jul 2003 20:33:39 PDT
Organization: EarthLink Inc. -- http://www.EarthLink.net
Xref: newssvr20.news.prodigy.com comp.databases.oracle.misc:129122

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.