INDEXes and UNIQUES and PRIMARY KEYS

From: Chris Bitmead <chris(dot)bitmead(at)bigfoot(dot)com>
To: pgsql-general(at)postgreSQL(dot)org
Subject: INDEXes and UNIQUES and PRIMARY KEYS
Date: 1999-04-27 00:54:55
Message-ID: 37250ADE.F1705137@bigfoot.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


If I have a UNIQUE or PRIMARY KEY clause on my class, does that create a
btree or hash index?

I guess if I have a UNIQUE constraint or PRIMARY KEY at class creation,
I don't have to create an index explicitely via 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:01:49 UNIQUE performance?
Previous Message Jim Jennis 1999-04-26 21:18:38 Re: [GENERAL] advice on buying sun hardware to run postgres