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/Emergency: +1.800.492.2240 Providing the most comprehensive PostgreSQL solutions since 1997 http://www.commandprompt.com/ Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate PostgreSQL Replication: http://www.commandprompt.com/products/