Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Costs of Nested Tables

Re: Costs of Nested Tables

From: spencer <spencerp_at_swbell.net>
Date: 2000/07/10
Message-ID: <a9xa5.296$BC3.91890@nnrp2.sbc.net>#1/1

i think the biggest costs are learning the new SQL constructs needed to manipulate the nested table, learning how to manage the nested table, and the inherint risks associated with new features.

i think more pertinent questions are:
are there any benefits of using a nested table ? and do the benefits outweigh the costs / risks ?

"Steve Parker" <steve_at_naweb.com> wrote in message news:3969F8D8.286B27D9_at_naweb.com...
>
> I was hoping somebody could shed some light on this issue for
 me...
>
> What additional costs are associated with using Nested Tables
 in Oracle
> - as opposed to using multiple separate tables. i.e.,
 Instead of
> having 10,000 tables, have one table with 10,000 rows where
 each row
> contains a nested table. (and each of the 10,000 tables might
 have
> 100-20,000 rows).
>
> Can somebody give me some pointers as to what costs this will
 impose,
> and if this is good design?
>
> Any help is very much appreciated.
>
> Thanks,
> Steve
>
>
Received on Mon Jul 10 2000 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US