Re: view or not?

Gang - Feng wrote:

> 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?

    I think the differences will not be very obvious provided that the view query and the select query from the three tables are the same.   

    To speed up the query, you can try to use view partition for query optimization.

---
Name   : Lun Wing San (Certified Oracle Database Administrator)

Title  : Oracle Application Developer of Hong Kong Productivity Council
         Oracle Database Administrator and System Administrator of QRC
Phone  : (852)27885841

This posting represents the personal opinions of the author. It is not the
official opinion or policy of the author's employer. Warranty expired when you
opened this article and I will not be responsible for its contents or use.