update large table

[reydp]

Ray,

PL/SQL Block always runs slower than a single update.

For a simple update, do it in a single statement. If possible, use parallel DML.

Yes Tamil, I do agree with you.
In fact I myself have posted before,
long time ago about using PARALLEL DML
also here in this forum.


PL/SQL Block always runs slower than a single update.-
- yes, it was actually a sort of a test to the poster. Davey, actually posted contesting the use of pl/sql to update before my post.

It'a trick that will work for small table
but not in huge one...heheh..my bad.