Welcome to WebmasterWorld Guest from

Forum Moderators: open

Message Too Old, No Replies

Difference between 'indexes' and 'primary keys'?

6:48 am on Apr 12, 2010 (gmt 0)

Preferred Member

10+ Year Member

joined:Nov 2, 2005
votes: 0

What is the difference between indexes and primary keys in phpmyadmin? (What way should they be used to gain the most speed?)

I tried to search for an existing topic as I'm sure it already exists, but couldn't find anything.
9:04 pm on Apr 15, 2010 (gmt 0)

Senior Member

WebmasterWorld Senior Member 10+ Year Member

joined:Feb 27, 2001
votes: 0

A primary key must be unique. Usually it's an integer ID that uniquely identifies each row.

Indexes are used to ... index ... the values in a given row so that they can be found more quickly.