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

Re: How can i tune this sql query ?

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: 18 Jan 2006 08:25:03 -0800
Message-ID: <1137601503.044781.68760@g49g2000cwa.googlegroups.com>


You might consider if WHERE LTRIM(RTRIM(ID)) || LTRIM(RTRIM(TO_CHAR(INUMBER))) can be changed to  (id, inumber) not in (select distinct id, inumber from ..... )

Also if the in clause query has very few duplicates it may be faster to search through them than to eliminate them. If there are no duplicates then the distinct clause is causing unnecessary work.

HTH -- Mark D Powell -- Received on Wed Jan 18 2006 - 10:25:03 CST

Original text of this message

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