Re: Is a better way to have the same result of this

From: Andrew Sullivan <andrew(at)libertyrms(dot)info>
To: PgSQL Performance ML <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Is a better way to have the same result of this
Date: 2002-12-05 19:57:50
Message-ID: 20021205145750.V4800@mail.libertyrms.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Thu, Dec 05, 2002 at 11:08:17AM -0800, Vernon Wu wrote:
> Ron,
>
> The gender is indexed.

Given that gender only has two (? Very few, anyway) values, I can't
believe an index will be much use: it's not very selective. Maybe
combining several columns in one index will help you.

A

--
----
Andrew Sullivan 204-4141 Yonge Street
Liberty RMS Toronto, Ontario Canada
<andrew(at)libertyrms(dot)info> M2P 2A8
+1 416 646 3304 x110

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Vernon Wu 2002-12-05 20:35:08 Re: Is a better way to have the same result of this
Previous Message Jean-Luc Lachance 2002-12-05 19:45:26 Re: Is a better way to have the same result of this