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
ciapecki wrote:
> Hi,
>
> Does indexing a very big table (about 5Mio records) on the columnA
> which can hold only values Y,N,<NULL> make sense?
>
Yes, that's what bitmap indexes were made for.
Thomas Received on Fri Aug 03 2007 - 02:54:58 CDT
![]() |
![]() |