Re: performance impact of index

From: Hans Forbrich <forbrich_at_yahoo.net>
Date: Fri, 21 May 2004 20:14:57 GMT
Message-ID: <5rtrc.4734$SQ2.1359@edtnps89>

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

'Cause there are some situations where bitmap indexes are counterprodutive and sometimes a waste of space.

See the DBA guide for the version you run for more info. Search for Bitmap Indexes in the archives. Received on Fri May 21 2004 - 15:14:57 CDT