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

Home -> Community -> Usenet -> c.d.o.server -> Re: Data Warehouse/BMI Help

Re: Data Warehouse/BMI Help

From: Doug Anderson <dathedba_at_mindspring.com>
Date: 1997/06/20
Message-ID: <5oe4of$q0j@camel4.mindspring.com>#1/1

Simon J Moore <moores_at_sequent.com> wrote:

>To use bitmap indexes you need a minimum of Oracle 7.3 with parallel
>query option installed.
 

>9 million rows is not too much for a single table unless the rows are
>quite long. It's best to partition on something that is fixed - like
>time - and avoid something like company structure which can change.
 

>You can partition using check constraints or by using the SQL of the
>union all view. I prefer the latter as it has no overhead when loading
>data.

But what if you need to allow updates on any table in the view? You can't do it with a 'union all' because Oracle won't let you.

Received on Fri Jun 20 1997 - 00:00:00 CDT

Original text of this message

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