by Michel Esber <michel@[EMAIL PROTECTED]
>
May 11, 2008 at 06:12 PM
Ok .. I know I sent a bad example. Here=B4s another try:
update T set field =3D 'new_value' where (ID) in (select ID from T where
field1=3D'xyz' and field2 =3D 'foo' fetch first 1000 rows only)
However , the plan has two index scans. Is there any better solution
with a single scan ?
The delete statement posted before has only one index scan ... Can I
achieve the same with update ?
Thanks, Michel
