Toggle navigation
Dashboard
Dashboard Tracker
Add / Edit My Forums
System Announcements
Discussion
Active Thread Feed
Top Threads Today
Top Threads This Week
Top Threads Library
Go!
View All
View All
Login
Logout
Home
Forums Index
Server Side
/
Databases
3:09 am Sep 21, 2026
This page requires javascript.
Forum Moderators:
open
Message Too Old, No Replies
Difference between 'indexes' and 'primary keys'?
jake66
Msg#:4114148
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
Msg#:4116574
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.
Join The Conversation
Register
For Free! -
Become a
Pro Member
!
See forum categories
-
Enter the Forum
Moderators and Top Contributors
Moderator List
| Top Contributors:
This Week
,
This Month
,
Aug
,
Jul
,
Archive
,
Top 100 All Time
,
Top Voted Members
Hot Threads This Week
September 2026 Google Search Observations
AdSense Earnings and Observations - September 2026
An old fashioned desktop WYSIWIG HTML editor
Hit a new milestone today, 1 million requests.
Home
Forums Index
Server Side
/
Databases
3:09 am Sep 21, 2026