Re: Designing Large tables

Lun Wing San (Oracle) wrote:
>
> Hitesh Patel wrote:
> >
> > We are in the process of creating an archive database which consists
> > of few tables of sizes ranging from 4 Gb to 16 Gbytes. Do you have
> > any suggestions for creating these tables in terms of partitioning the
> > tables, spreading across disks, accessing the data, clustering etc.
> > Does anyone has this kind of scenario or know of any articles on the
> > internet ?
>
> You can try to use partition view to implement it. By using partition
> views, you will gain several advantages in performance.

This sounds interesting but what is a partition view?

-- 
Sport radio: people listening to people watching people having fun
Mailto:roger.wernersson_at_adra.se
BTW: All opinions are mine, all mine, and nobody's but mine.