On Sun, 2005-04-24 at 09:49 -0700, Rich Shepard wrote: > I'm converting mysql tables to postgres. One of the tables has this: > > PRIMARY KEY (org_id, contact_id), > KEY contact (contact_id, org_id) > > Is there really a difference in the two indices if the sequence of fields > is reversed?
yes. for example, only the first one can be used for ORDER BY org_id gnari ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
