Jeremy Zawodny wrote:
> On Sat, Jul 07, 2001 at 07:22:19AM -0700, Ken Sommers wrote:
>
>> Does it make any sense to create an index on the primary key?
>
> Primary Keys are automatically indexed. In fact, you might say that a
> primary key is just a special type of index (it is).
There are som
On Sat, Jul 07, 2001 at 07:22:19AM -0700, Ken Sommers wrote:
>
> Does it make any sense to create an index on the primary key?
Primary Keys are automatically indexed. In fact, you might say that a
primary key is just a special type of index (it is).
Jeremy
--
Jeremy D. Zawodny, <[EMAIL PROTECTE
HI,
Does it make any sense to create an index on the primary key?
Ken
- Original Message -
From: "Paul DuBois" <[EMAIL PROTECTED]>
To: "Fournier Jocelyn [Presence-PC]" <[EMAIL PROTECTED]>;
<[EMAIL PROTECTED]>
Sent: Friday, July 06, 2001 3:49 PM
At 12:14 AM +0200 7/7/01, Fournier Jocelyn [Presence-PC] wrote:
>Hi,
>
>Is there any structural difference between a PRIMARY KEY and a UNIQUE key ?
>
>Thanks ;)
>
>Jocelyn Fournier
>Presence-PC
>www.presence-pc.com
They're mostly the same, with these differences:
There can only be one PRIMARY KE
