aircooled57 Posted March 16, 2008 Share Posted March 16, 2008 i just created a table called users within a database called webdata i setup the fields for the table which it then created i then noticed when i was looking at the table it said there was no index defined. what is an index,do i need one and what does it do? thnx Link to comment https://forums.phpfreaks.com/topic/96402-mysql-phpmyadmin-indexes/ Share on other sites More sharing options...
BlueSkyIS Posted March 16, 2008 Share Posted March 16, 2008 "what is an index,do i need one and what does it do?" a lot to explain. short story: an index helps the database locate records faster and often helps tie records between tables. you should have one on every table. do you need it? depends on the size of your database, number of queries, etc. but i would just become used to using then always. http://www.databasejournal.com/features/mysql/article.php/1382791 Link to comment https://forums.phpfreaks.com/topic/96402-mysql-phpmyadmin-indexes/#findComment-493412 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.