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)

10+ Year Member

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)

WebmasterWorld Senior Member 10+ Year Member

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.

Featured Threads

Hot Threads This Week

Hot Threads This Month