Indexing data warehouses
From: Gary Nilges <gnilges_at_qni.com>
Date: 1996/01/29
Message-ID: <4ejab5$77f_at_suba01.suba.com>#1/1
Date: 1996/01/29
Message-ID: <4ejab5$77f_at_suba01.suba.com>#1/1
I was told that data warehouses traditionally didn't have alot of
indexes. I would think, though, that since this is a read-only OLAP
instance with users pounding the heck out of it with a querey tool,
that you'd want to index the heck out of it.
What are the drawbacks (if any) to indexing in a read-only data
warehouse? Was I told wrong, or are DW's usually not highly indexed?
This is an Oracle 7 installation on an HP UNIX box, btw.
thanks,
...gary Received on Mon Jan 29 1996 - 00:00:00 CET