and do not update the table.
--
Niall Litchfield
Oracle DBA
Audit Commission Uk
"Stefan Olausson" <qhsstol_at_hotmail.com> wrote in message
news:fda9c411.0111050753.22c671a8_at_posting.google.com...
> damien.salvador_at_via.ecp.fr (Damien Salvador) wrote in message
news:<slrn9u2icq.aj0.damien.salvador_at_zen.via.ecp.fr>...
> > On 1 Nov 2001 05:05:01 -0800, Stefan Olausson
> > <qhsstol_at_hotmail.com> a écrit:
> > There is a case when Null can be indexed but I cannot seem to remember
when...
>
> Yes, NULL-values are always indexed when you use BITMAPPED indexes,
> if I read the documentation correctly.
> But such are only useful when you have
> relatively few distinct values in a column.
>
> /Stefan
Received on Mon Nov 05 2001 - 10:10:13 CST
