RE: Poor Performance of Nested Tables

Hi Madhavi

>We have a table which has 2 Nested Tables and a VarArray as columns =
besides
>other datatypes. This table holds 2 million records. When deleting =
records
>from this table, we noticed that it does a Full Table scan of the =
Nested
>tables for each and every row we are deleting resulting in very poor
>performance.
>
>Does anyone have any good suggestions on how we can improve performance =
for
>this? Anyone encountered this situation before?

Do you already tried to create an index on the column NESTED_TABLE_ID?


HTH
Chris
--
http://www.freelists.org/webpage/oracle-l

Other related posts: