Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: view or not?
For data mining (oracle7.3) use partition views. Instead of making 3 views
create 3 tables and distribute data in them . Then create a view as
selection * from t1 union all select * from t2 union all select * from t3.
Also make sure these three tables are on diff. disks so that you get better
performance.
Prab Athilat
prab.athilat_at_fmr.com
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 Fri Feb 28 1997 - 00:00:00 CST