Re: Query rewrite

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Fri, 15 Jul 2005 21:52:39 +0200
Message-ID: <at4gd1ls1ds5k251uj7amru8fo5irpk9ag@4ax.com>

On 15 Jul 2005 11:08:28 -0700, "Ryan S" <rshevchi_at_vt.edu> wrote:

>Yes of course, but that doens't make the query any faster by removing
>them. Any info on increasing performance?

You state that removing 2 unnecessary sort operations (ie the distincts) don't make the query faster? I would disagree with you. But apparently you already seem to know all answers, so why ask for help here?

--
Sybrand Bakker, Senior Oracle DBA

Received on Fri Jul 15 2005 - 14:52:39 CDT