Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: indexing a column with only 2 or 3 values
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
![]() |
![]() |