Re: Index based database?

Geoff Muldoon wrote:
> Junk_at_webthere.com says...
> > DA Morgan wrote:
> > >
> > > Is is a "real" warehouse designed as one or just a copy of an OLTP schema?
> > > Are they being used?
> > > What index type?
> >
> > 1. Kimbal Based Warehouse no legacy OLTP and no ODS, designed for
> > warehouse/reporting
> >
> > 2. Indexes being used: not always - but that's another issue.
> >
> > 3. Index type = B*Tree, all B*Tree
>
> It is often common for indexes in a DW to be bitmap rather than b-tree.
>
> Good book by Bert Scalzo specifically on Oracle/DW/star schemas is worth a
> read.
>
> GM

Yes, I have all of Bert's books, the toad suff is a little old now. Kimball's too; autographed even.

Thanks for the reply, it indicates I still have my sanity. Bitmap is key, but we have none on this database. Received on Thu Dec 14 2006 - 22:39:30 CST