Toim is correct in that the presence of a for each row update trigger
would turn the bulk update into a single row update. What else may
harm the update performance is if the java class was written such that
the update actually updates the entire row rather than just the column
in question. While the java code in the application may show only one
column what actually is passed to Oracle may be different. The
underlying classes may need to be exaimined.
HTH -- Mark D Powell --
Received on Fri Feb 04 2005 - 08:41:35 CST
