Re: DISTINCT Question

From: "Steinar H(dot) Gunderson" <sgunderson(at)bigfoot(dot)com>
To: Y Sidhu <ysidhu(at)gmail(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: DISTINCT Question
Date: 2007-05-08 19:55:51
Message-ID: 20070508195551.GA7552@uio.no
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Tue, May 08, 2007 at 12:52:35PM -0700, Y Sidhu wrote:
> Does using DISTINCT in a query force PG to abandon any index search it might
> have embarked upon?

No.

If you need help with a specific query, please post it, along with your table
definitions and EXPLAIN ANALYZE output.

/* Steinar */
--
Homepage: http://www.sesse.net/

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Joshua D. Drake 2007-05-08 19:57:19 Re: DISTINCT Question
Previous Message Y Sidhu 2007-05-08 19:52:35 DISTINCT Question