Re: cluster at a time processing

Here is two ideas:

1. Are there any keys that multiple rows share? For example zipcode or state code. Or is every row updated based on a unique, primary key? If there is a key that is shared, then you could fetch all distinct key values in a loop and update that "set" with the appropriate value.
2. Pro*C has the ability to use array updates. The rows are fetched into an array in Pro*C, then the arrays is updated with new values, then the whole array is sent back to the database with one call. The can seriously speed up updates since it makes far fewer call the Oracle Kernel.

If you can give me some examples, I might be able to come up with some more ideas.

Good luck.

Brian Price bprice2000_at_sprintmail.com

ssharma_at_clearnet.com wrote in message <883769763.1711669254_at_dejanews.com>...
>I need to make changes to a massive, massive table - currently I use a
>pl/sql procedure to loop through the table committing after each million
>updates.
>
>I am wondering if there is an easy way to update a cluster at a time. ie
>instead of updating a record each time through the loop and doing a
>commit on the millionth loop, could I update a cluster each time through
>the loop and the next time through the loop use the next cluster (or
>block or file).
>
>I realise I can easily get to clusters through rowid to char
>manipulations, I am hoping there are easier ways to get hold of this
>info.
>
>Would this update - by - cluster instead of update - by - rowid provide
>any speedups?
>
>-------------------==== Posted via Deja News ====-----------------------
> http://www.dejanews.com/ Search, Read, Post to Usenet
Received on Fri Jan 02 1998 - 00:00:00 CST