Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Index organized table as an aggregate table

Index organized table as an aggregate table

From: paquette stephane <stephane_paquette_at_yahoo.com>
Date: Fri, 1 Dec 2000 07:18:45 -0800 (PST)
Message-Id: <10697.123399@fatcity.com>


Hi,

I've not played much with IOT.
In a DW application , Oracle 816, we have an aggregate that is linked to 8 dimensions with only one data field.

Is that a good candidate for an IOT ?
Will Oracle still do a star-transformation on a IOT with bitmap indexes ?

TIA



Stephane Paquette
DBA Oracle
stephane_paquette_at_yahoo.com

Do You Yahoo!?
Yahoo! Shopping - Thousands of Stores. Millions of Products. http://shopping.yahoo.com/ Received on Fri Dec 01 2000 - 09:18:45 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US