List:General Discussion« Previous MessageNext Message »
From:Michael Widenius Date:June 8 1999 11:54pm
Subject:Primary key vs. Index
View as plain text  
>>>>> "Daevid" == Daevid Vincent <daywalker@stripped> writes:

Daevid> Are PRIMARY KEY and INDEX essentially the same as far as searching and speed
> are
Daevid> concerned?

PRIMARY KEY will be a little faster if you specify all columns
as MySQL in this case doesn't have to check for multiple matching rows!

Regards,
Monty
Thread
Primary key vs. IndexDaevid Vincent9 Jun
  • Primary key vs. IndexMichael Widenius9 Jun