Re: Distinct or Group by
From: Mikito Harakiri (mikharakiri_nospaum_at_yahoo.com)
Date: 11/19/04
- Next message: Hugo Kornelis: "Re: Help with Date/Time query"
- Previous message: oj: "Re: Distributed Query Strangeness"
- In reply to: Reg Besseling: "Distinct or Group by"
- Messages sorted by: [ date ] [ thread ]
Date: 19 Nov 2004 15:00:08 -0800
"Reg Besseling" <regbes.nospam@hotmail.com> wrote in message news:<08adnRRaBcSqDQHcRVn-2Q@is.co.za>...
> Is it more efficient to use
>
> select MyValue
> from MyTable
> group by MyValue
>
> or
>
> Select distinct MyValue
> from MyTable
They always return the same set of values, right? Suppose they indeed
to have different implementations, and one happen to be more efficient
than the other. Then, it might be easily argued that optimizer have
chosen inefficient implementation in one of the cases.
- Next message: Hugo Kornelis: "Re: Help with Date/Time query"
- Previous message: oj: "Re: Distributed Query Strangeness"
- In reply to: Reg Besseling: "Distinct or Group by"
- Messages sorted by: [ date ] [ thread ]
