UNIQUE performance?

From: Chris Bitmead <chris(dot)bitmead(at)bigfoot(dot)com>
To: pgsql-general(at)postgreSQL(dot)org
Subject: UNIQUE performance?
Date: 1999-04-27 01:01:49
Message-ID: 37250C7C.4DE0952F@bigfoot.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


If I want to have an index on oid, which will obviously be unique
anyway, is it more efficient to have or not to have the UNIQUE option on
CREATE INDEX ?

In response to

  • 9k limit? at 1999-04-22 20:20:11 from Justin Long

Browse pgsql-general by date

  From Date Subject
Next Message Chris Bitmead 1999-04-27 01:14:52 INDEXes and "*" notation ?
Previous Message Chris Bitmead 1999-04-27 00:54:55 INDEXes and UNIQUES and PRIMARY KEYS