| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.misc -> Re: Question about select and update
> There might be still better ways, but try updating by rowid instead of
> by id column. Your select statement can select the rowid in addition to
> the necessary data, and the update can use the same value to locate the
> row without searching index or FTS.
Yes, I am using rowid already. But the update is still not fast enough.(20-30msec) Received on Wed Dec 11 2002 - 22:34:01 CST
 |
 |