RE: chained rows and performance

From: Hamid Alavi <HamidA_at_aimdirect.co.nz>
Date: Mon, 9 Oct 2000 10:08:04 +1300
Message-Id: <10643.118741@fatcity.com>

Easiest solution is export table and then import it again.

-----Original Message-----
From: lack_at_baq-bayern.de [mailto:lack_at_baq-bayern.de] Sent: Monday, 9 October 2000 02:31
To: Multiple recipients of list ORACLE-L Subject: chained rows and performance

Hello,

i'm getting very poor performance which i suspect is due to a high number of chained rows appearing after trying to insert data into a large number of columns of an existing table while using a cursor loop.

can anyone help me?

Thanks,

Regards,

Nick

Mit freundlichen Grüssen
Nicholas Lack

Bayerische
Arbeitsgemeinschaft für Qualitätssicherung in der stationären Versorgung
Westenriederstr. 19

80331 München

TEL.: 089 21159012 Received on Sun Oct 08 2000 - 16:08:04 CDT