Re: how quick query can be

update (select b.b2 from b where b.b1 = a.a1) set a2 = b2

Ok, now correct.
Can you propose something quicker now ?

<sybrandb_at_yahoo.com> wrote in message news:a1d154f4.0307202352.6fd713ec_at_posting.google.com...
> "Julia Sats" <julia.sats_at_sympatico.ca> wrote in message
 news:<ijHSa.769$1I5.141057_at_news20.bellglobal.com>...
> > I have two tables A(a1 number, a2 number) and B(b1 number, b2 number)
> > a.a1 and b.b1 are join columns .
> > I need to update values of a2 by values of b2.
> >
> > we can use such update quere
> > update A set a2 = (select b.b2 from b where b.b1 = a.a1)
> >
> > Can you propose something quicker ?
> >
> > Thanks
>
> Switch to a different database. Your query is incorrect too.
>
> Sybrand Bakker
> Senior Oracle DBA
Received on Tue Jul 22 2003 - 02:17:27 CEST