On Tue, 2007-05-08 at 14:52, Y Sidhu wrote:
> Does using DISTINCT in a query force PG to abandon any index search it
> might have embarked upon?
explain analyze select distinct request from businessrequestsummary
where lastflushtime between now() - interval '30 minutes' and now();
Y Sidhu wrote:
Does using DISTINCT in a query force PG to abandon any index search it
might have embarked upon?
Depends on the where clause.
--
Yudhvir Singh Sidhu
408 375 3134 cell
--
=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emerg
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 */
--
Does using DISTINCT in a query force PG to abandon any index search it might
have embarked upon?
--
Yudhvir Singh Sidhu
408 375 3134 cell
