RE: [GENERAL] INDEXes and UNIQUES and PRIMARY KEYS

From: "Jackson, DeJuan" <djackson(at)cpsgroup(dot)com>
To: Chris Bitmead <chris(dot)bitmead(at)bigfoot(dot)com>, pgsql-general(at)postgreSQL(dot)org
Subject: RE: [GENERAL] INDEXes and UNIQUES and PRIMARY KEYS
Date: 1999-04-27 19:21:06
Message-ID: D05EF808F2DFD211AE4A00105AA1B5D20DCBA5@cpsmail
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?
btree

> 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 ?
correct

-DEJ

Browse pgsql-general by date

  From Date Subject
Next Message Jackson, DeJuan 1999-04-27 19:22:35 RE: [GENERAL] UNIQUE performance?
Previous Message Jackson, DeJuan 1999-04-27 19:18:31 RE: [GENERAL] Speed