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 Quote Link to comment 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 Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.