Re: Optimize Select on update column

Kalmact wrote:

> May be we are talking about different things here. What I meant is, a
> forall can be used only for Inserts, updates or deletes. Now
> processing sounds more like pl/sql routines than sqls.. If I have to
> update without any other processing I would simply do
> UPDATE Table1
> SET status = 'Y'
> WHERE status = 'N'
> AND non_unique_key_code = <key>;
> rathen than doing bulk bind and for all...
>
> Regards,
> Kal

Absolutely. I assumed from your comment that you thought that between a bulk collection and the FORALL no processing could be done on the collected rows.

If something can be done with a simple UPDATE statement there is rarely a good reason not to use it.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)