Welcome to WebmasterWorld Guest from 54.158.36.59

Forum Moderators: open

Message Too Old, No Replies

Difference between 'indexes' and 'primary keys'?

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

5+ 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