Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Strange CBO Behaviour with a Bitmap Index
Jimbo1 wrote:
> >Is it possible to partition or subpartition the table on
> >REPORT_POPULATED column.
> >Row movement should be enabled for the table.
> >
> >Joseph Amalraj
>
> Hi Joseph,
>
> I think that would lend itself to list partitioning extremely well.
> Unfortunately, I'm running in an 8i database, so that's not an option.
Then perhaps express 'N' and 'Y' as ranges.
Regarding the index, if 75% of rows are 'N' I might be tempted to change it from a Y/N column to Y/NULL. Received on Thu Feb 09 2006 - 10:31:18 CST