johnsmith153 Posted March 14, 2009 Share Posted March 14, 2009 This is what I will do: (using PHP) Creating tables / indexes: If creating a table with fields: uniqueID username password name age faveColour Height -I would probably set uniqueID and username as Primary Key and password as indexed (and no other indexes) (as I will regularly search for username/password when they log in AND often will search just for uniqueID to call the record for other reasons.) Is this right? Do I understand indexing? Quote Link to comment https://forums.phpfreaks.com/topic/149436-please-check-my-understanding-of-indexing-in-mysql/ Share on other sites More sharing options...
Mchl Posted March 14, 2009 Share Posted March 14, 2009 You seem to understand at least necessary basics (create indexes on fields you perform searches on). Not bad for starters and it's probably most common use for indexes. Note however that it is not all there is to know about them. If you want to learn more: http://dev.mysql.com/doc/refman/5.1/en/mysql-indexes.html Quote Link to comment https://forums.phpfreaks.com/topic/149436-please-check-my-understanding-of-indexing-in-mysql/#findComment-784855 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.