Re: performance impact of index
From: Daniel Morgan <damorgan_at_x.washington.edu>
Date: Fri, 21 May 2004 09:41:57 -0700
Message-ID: <1085157722.596077_at_yasure>
Date: Fri, 21 May 2004 09:41:57 -0700
Message-ID: <1085157722.596077_at_yasure>
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)Received on Fri May 21 2004 - 18:41:57 CEST