Re: Strange CBO Behaviour with a Bitmap Index

From: William Robertson <william.robertson_at_bigfoot.com>
Date: 9 Feb 2006 08:31:18 -0800
Message-ID: <1139502678.153354.211630@g47g2000cwa.googlegroups.com>

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