RE: [GENERAL] INDEXes and UNIQUES and PRIMARY KEYS

Jackson, DeJuan <djackson@cpsgroup.com>

From: "Jackson, DeJuan" <djackson@cpsgroup.com>
To: Chris Bitmead <chris.bitmead@bigfoot.com>, pgsql-general@postgreSQL.org
Date: 1999-04-27T19:21:06Z
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