Re: Nested table - How do I ensure delete-row perform well ?

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Mon, 8 Apr 2002 10:12:17 +0100
Message-ID: <1018257088.29291.0.nnrp-12.9e984b29@news.demon.co.uk>

If you mean a nested table in the proper 'oracle-object' sense, then the nested
table data will automatically disappear
with the parent row.

However you may want to create a
compressed index on the nested_table_id
(perhaps concatenating some other columns) of the table holding the nested table as this may improve performance. You may also want to consider making the nested table an IOT.

(Chapter 16 of the book).

--
Jonathan Lewis
http://www.jlcomp.demon.co.uk

Host to The Co-Operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html

Author of:
Practical Oracle 8i: Building Efficient Databases


Max wrote in message <13eb3a51.0204080041.158b129_at_posting.google.com>...


>I've a table with a nested table. If I delete a row from parent table,

>how do I ensure that it trigger a delete into nested table ?

Received on Mon Apr 08 2002 - 04:12:17 CDT