Does an index get create for a Primary Key?

Started by Thomas LeBlancabout 22 years ago2 messagesgeneral
Jump to latest
#1Thomas LeBlanc
thomasatiem@hotmail.com

Does an index get created for a Primary Key or is it just a constraint?

Thanks,
ThomasLL

_________________________________________________________________
Free up your inbox with MSN Hotmail Extra Storage. Multiple plans available.
http://join.msn.com/?pgmarket=en-us&page=hotmail/es2&ST=1/go/onm00200362ave/direct/01/

#2Alvaro Herrera
alvherre@dcc.uchile.cl
In reply to: Thomas LeBlanc (#1)
Re: Does an index get create for a Primary Key?

On Wed, Mar 31, 2004 at 03:39:01PM -0600, Thomas LeBlanc wrote:

Does an index get created for a Primary Key or is it just a constraint?

Yes, an unique btree index.

--
Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
"La Primavera ha venido. Nadie sabe como ha sido" (A. Machado)