Re: Why DISTINCT is costly?

From: Noons <wizofoz2k_at_yahoo.com.au>
Date: Mon, 12 Sep 2005 20:34:16 +1000
Message-ID: <432559a7$0$12646$5a62ac22@per-qv1-newsreader-01.iinet.net.au>

juhunu_at_gmail.com apparently said,on my timestamp of 12/09/2005 4:45 PM:

>
> Any help in reducing the cost in using DISTINCT would be of much help.

Drop the DISTINCT.

-- 
Cheers
Nuno Souto
in sunny Sydney, Australia
wizofoz2k_at_yahoo.com.au.nospam

Received on Mon Sep 12 2005 - 05:34:16 CDT

This message: [ Message body ]
Next message: Andy Hassall: "Re: pl/sql, excel, xml, utf-8 data - excel refuses to show data"
Previous message: Martin: "Re: Impersonate a Oracle User"
In reply to: juhunu_at_gmail.com: "Why DISTINCT is costly?"
Next in thread: Umberto: "Re: Why DISTINCT is costly?"

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