Re: partions in Oracle 8

Haven't tried them, but played with them in the Oracle8 class.

Just remember that there's an overhead associated with partitions, so only use them for big tables. Also, partitioning is a separately licensed option, so to be legal, be sure you've paid for it!

judie.stroup_at_lmco.com

John Bishop wrote:
>
> I have a conifguration that really lends itself to either using either a
> series of unions with multiple tables, or implimenting partitions in
> Oracle 8.
>
> Has anyone had any good or bad experiences with partitions?
>
> {snip}
>
> So what are your suggestions. The partions look easier to manager, but
> the view lends itself to simplicty (other than the moving around) and
> it's proven technology.
>
> Good or bad experiences are appreciated.
>
> JB
Received on Tue Mar 10 1998 - 00:00:00 CST