Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Nested table or independent table
1 is relationally correct
2 looks like to be relationally correct, but likely it isn't
It also probably results in performance problems, as, as far as I know,
nested tables can't be indexed.
And it makes your application non-portable to other database products.
-- Sybrand Bakker Senior Oracle DBAReceived on Wed Feb 01 2006 - 06:25:29 CST