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: view or not?

Re: view or not?

From: Gang - Feng <g0f4653_at_cs.tamu.edu>
Date: 1997/02/27
Message-ID: <33160757.4BAA@cs.tamu.edu>#1/1

Ian Stevenson wrote:
>
> You could use a bitmapped index on the distinguishing column of the
> category to make the views faster but I personally would be tempted to
> partition the table by category (i.e. have 3 tables) and use a view based
> on a "union all" when you need to access the whole.
> Ian
> ----
> Ian Stevenson (coauthor of Oracle Design published by O'Reilly and
> Associates)

Thank you for reply. But what is bitmapped index? How to create this kind of index?

Feng
>
> Gang - Feng <g0f4653_at_cs.tamu.edu> wrote in article
> <331530FE.729D_at_cs.tamu.edu>...
> > Hi,
> > In our data mining system, we aggregate a lot of data(more than
> > 30,000 and will be larger along with time) into one main table. But
> > these data contain 3 categories. We plan to make three views for them.
> > My question is if this way is much slower than that we retrieve from
> > three different tables. If it is just light slower, I think we can
> > endure it. If it is not, we have to think another way. Do you have
> > any idea?
> > Thanks a lot.
> >
> > Feng
> >
Received on Thu Feb 27 1997 - 00:00:00 CST

Original text of this message

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