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 can i tune this sql query ?

How can i tune this sql query ?

From: Pankaj <pg_gupta78_at_rediffmail.com>
Date: 18 Jan 2006 07:05:37 -0800
Message-ID: <1137596737.588194.198010@z14g2000cwz.googlegroups.com> 





Hi there,



Can u pls tell me how can i tune this query ?



at any time records in UnitIDTbl and INFOTBL is not more then 50000.



INSERT INTO UnitIDTbl


SELECT DISTINCT ID,INUMBER,'E-NOTFOUND'



FROM IMPORTTBL



WHERE LTRIM(RTRIM(ID)) || LTRIM(RTRIM(TO_CHAR(INUMBER)))

NOT IN



(SELECT DISTINCT LTRIM(RTRIM(ID)) || LTRIM(RTRIM(TO_CHAR(INUMBER)))

FROM INFOTBL )



 AND (IMODE = 'N'  OR IMODE = 'I' ) 



AND ATYPE != 'R' 



Thanks,


Pankaj
Received on Wed Jan 18 2006 - 09:05:37 CST












Original text of this message













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