Subject Re: [ib-support] Update in SP
Author Jason Wharton
> Something like this will work:
> for select <primary key> from <table> where <condition>
> into <variable>
> do begin
> update <table> set <assignments> where <primary key> =
> end;
> There are a couple of variants that might be slightly faster (using
> the undocumented cursor mechanism or db_keys) but as all the structures
> you're using will be in cache, the difference is unlikely to be
> measurable.

Using the DB_KEY provides a significantly measurable difference, IME.

Jason Wharton
CPS - Mesa AZ