RE: Poor Performance of Nested Tables
- From: "Christian Antognini" <Christian.Antognini@xxxxxxxxxxxx>
- To: <MKanugo@xxxxxxxxxx>
- Date: Thu, 2 Jun 2005 15:59:51 +0200
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
