| Welcome to WebmasterWorld Guest from 184.108.40.206 |
register, free tools, login, search, subscribe, help, library, announcements, recent posts, open posts,
|Pubcon Platinum Sponsor 2014|
|Difference between 'indexes' and 'primary keys'?|
| 6:48 am on Apr 12, 2010 (gmt 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)|
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