Re: order of data in array for Pro*C array insert/update

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Fri, 1 Oct 1999 18:20:26 +0100
Message-ID: <938798617.12758.3.nnrp-08.9e984b29@news.demon.co.uk>

You can get some benefit, but it depends on the number of different indices, and the scattering of the data, and the probability of having to re-read blocks which get flushed from memory.

It's impossible to give an answer without some detailed information about the data.

Jonathan Lewis
Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk

Andris Nestors wrote in message <7t2ecv$2it$1_at_supernews.com>...
>We are trying to extract the last morsel of performance out of both Oracle
>8.1.5 and Oracle 7.3.4.
>
>We are using Pro*C array inserts and Pro*C array updates via ROWID for all
>SQL.
>
>Question: does the order of the data in the array have any bearing on the
>performance of the operation ?
>
>E.g. should I order the data in index order ? Or ROWID order ? Or does
the
>order not matter at all ?
>
>Thanks for any help
>Andris
>---
>andris.nestors_nospam_at_ac.com
>
>
Received on Fri Oct 01 1999 - 12:20:26 CDT