Re: Costs of Nested Tables

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