homepage Welcome to WebmasterWorld Guest from 54.227.215.140
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
Pubcon Platinum Sponsor 2014
Home / Forums Index / Code, Content, and Presentation / Databases
Forum Library, Charter, Moderator: open

Databases Forum

    
Difference between 'indexes' and 'primary keys'?
jake66

5+ Year Member



 
Msg#: 4114146 posted 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.

 

physics

WebmasterWorld Senior Member 10+ Year Member



 
Msg#: 4114146 posted 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.

Global Options:
 top home search open messages active posts  
 

Home / Forums Index / Code, Content, and Presentation / Databases
rss feed

All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Home ¦ Free Tools ¦ Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About ¦ Library ¦ Newsletter
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved