Re: JOINS and non use of indexes

From: "Ian Cass" <ian(dot)cass(at)mblox(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: JOINS and non use of indexes
Date: 2002-04-08 12:44:34
Message-ID: 002d01c1defb$23603630$6602a8c0@salamander
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Of course, the messages index looks like this...

CREATE INDEX messages_200204_ix2 ON messages_200204 USING btree (client_id,
user_name);

Duh!

> -- Index: messages_200204_ix1
> CREATE UNIQUE INDEX messages_200204_ix1 ON messages_200204 USING btree

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Jaume Teixi 2002-04-08 14:28:23 best method for select within all dimensions of an array
Previous Message Ian Cass 2002-04-08 12:35:28 JOINS and non use of indexes