Hello,
with good indeces 100 000 rows is basically nothing.

Give it a try.

Peter

Nick Meyer wrote:
> What is the best way to UPDATE a row only if values are different? We
> have a mainframe extract that literally has 100,000 rows and am worried
> about the performance of just running INSERTs each night.
>
> Is there a simple comparison command or would you have to nest a SELECT
> statement? Thank you,
>
> Nick
>
>