Re: is it possible to make this faster? - Mailing list pgsql-performance

On May 25, 2006 01:31 pm, "Merlin Moncure" <mmoncure@gmail.com> wrote:
> > SELECT DISTINCT ON (a, b) a, b, c FROM t ORDER BY a DESC, b DESC, c
> > DESC;
>
> that is actually slower than group by in my case...am i missing
> something? (both essentially resolved to seq_scan)

Try it with an index on a,b,c.

--
Alan