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?
Thanks,
Rich
-- Dr. Richard B. Shepard, President Applied Ecosystem Services, Inc. (TM) <http://www.appl-ecosys.com> Voice: 503-667-4517 Fax: 503-667-8863
---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
