Re: Select DISTINCT question

From: <Rick_Cale_at_teamhealth.com>
Date: Wed, 06 Feb 2002 08:03:11 -0800
Message-ID: <F001.004073F5.20020206073828@fatcity.com>

IMHO since they both require Oracle to sort the table and you are doing a full table scan in both cases the performance would be virtually the same.

Rick

                                                                                       
                                 
                    "Seefelt, Beth"                                                    
                                 
                    <Beth.Seefelt_at_tetl        To:     Multiple recipients of list 
ORACLE-L <ORACLE-L_at_fatcity.com>       
                    eyusa.com>                cc:                                      
                                 
                    Sent by:                  Subject:     Select DISTINCT question    
                                 
                    root_at_fatcity.com                                                   
                                 
                                                                                       
                                 
                                                                                       
                                 
                    02/06/2002 09:53                                                   
                                 
                    AM                                                                 
                                 
                    Please respond to                                                  
                                 
                    ORACLE-L

Hi everyone,

Is one of these more correct than the other ?

select distinct customer_number, address_code from orders;
select customer_number, address_code from orders group by customer_number,address_code;

Our developers do the 1st one mostly. It always bothers me, I'm not sure why, I guess I just think of it as looking ambiguous even though it does return the same result as the second option.

Any opinions? Does it matter at all?

TIA, Beth

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author:
INET: Rick_Cale_at_teamhealth.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Wed Feb 06 2002 - 10:03:11 CST