Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Poor Performance of Nested Tables

RE: Poor Performance of Nested Tables

From: Christian Antognini <Christian.Antognini_at_trivadis.com>
Date: Thu, 2 Jun 2005 15:59:51 +0200
Message-ID: <7F0C000A3ABA6241A10C9ABF37EEB46D0A4C76@MSXVS01.trivadis.com>


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
Received on Thu Jun 02 2005 - 10:10:04 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US