Re: performance impact of index

Gordon wrote:
> 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

You mean other than performance and scalability? No!

Database systems always perform better when people, without application of research, reason, or synapse, make things bigger, add overhead, and otherwise assume that if one is good many is better.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)