| Welcome to WebmasterWorld Guest from 22.214.171.124 |
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
|Pubcon Platinum Sponsor 2014|
|Difference between 'indexes' and 'primary keys'?|
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.
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.
All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved