"Gordon" <gordon_t_wu_at_hotmail.com> wrote in message news:<HEorc.290$Ny6.915_at_mencken.net.nih.gov>...
> Hi,
>
> I have a schema which is highly denormalized and purely read-only. For the
> purpose of fast data access, is there any reason not to create a bitmap
> index on every field for every table?
>
> Gordon
1- Waste of storage space
2- Waste of SQL plan parsing time
3- Waste of statistics generation time
4- Possibility of very erroneous execution plans (especially if
statistics not up-to-date).
...
Daniel
Received on Fri May 21 2004 - 15:09:20 CDT
