Re: view or not?

From: Ian Stevenson <stevenson_at_logica.com>
Date: 1997/02/27
Message-ID: <01bc24c6$443b6900$e610ea9e@p014138.logica.co.uk>#1/1

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)

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