Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> how to make it to be faster?

how to make it to be faster?

From: Alan Tang <tstang_at_cse.cuhk.edu.hk>
Date: 1996/10/29
Message-ID: <555ins$lqj@eng-ser1.erg.cuhk.hk>#1/1

hi there,

  here's part of the sql in a pro C:

  select a, b, c
  from table1 A, table2 B
  where
   A.account(+) = B.account;

  now, what i wanna ask is that how to rewrite the above sql with the removal of (+) so that the running time could become shorter? thks!

b rgds,
at Received on Tue Oct 29 1996 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US