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

This message: [ Message body ]
Next message: Tarby777: "Tuning index tablespaces"
Previous message: Niall Litchfield: "Re: Suggest books for beginner, and good as a reference for later use"
In reply to:(deleted message) A. Dischner: "Re: How can i tune this sql query ?"
Next in thread: Robert Klemme: "Re: How can i tune this sql query ?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

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