Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Designing Large tables
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.
--- Name : Lun Wing San Title : Oracle Application Developer of Hong Kong Productivity Council Oracle Database Administrator and System Administrator of QRC Phone : (852)27885841Received on Thu Jan 30 1997 - 00:00:00 CST