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

Home -> Community -> Usenet -> c.d.o.server -> Re: indexing a column with only 2 or 3 values

Re: indexing a column with only 2 or 3 values

From: bdbafh <bdbafh_at_gmail.com>
Date: Mon, 06 Aug 2007 22:33:43 -0000
Message-ID: <1186439623.960027.253760@g4g2000hsf.googlegroups.com>


On Aug 4, 11:51 am, Helma <bad_elef..._at_hotmail.com> wrote:
> > Ideally you might arrange the design such that the small number of
> > rows you typically want to identify are flagged with a 'Y' (say) and
> > the rest left null. Then a standard btree index on that column would
> > be compact and efficient.
>
> Redesign? What's wrong with my suggestion to create an index on only
> the Y value's?
>
> H.

Perhaps because FBIs can lead to wrong results returned prior to the 10.2.0.3 patchset being applied?

Paging Noons!

-bdbafh Received on Mon Aug 06 2007 - 17:33:43 CDT

Original text of this message

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