johnsmith153 Posted June 17, 2009 Share Posted June 17, 2009 I am searching most of time for columns A, B, C, D However, I also search a lot for B,C,D only. Also, sometimes I will search for A and just and another column E (A and E only) would it be best to do index as A, E, B, C, D or will I have to create more than one index? Quote Link to comment https://forums.phpfreaks.com/topic/162576-simple-mysql-index/ Share on other sites More sharing options...
RussellReal Posted June 17, 2009 Share Posted June 17, 2009 looks like you're playing the guitar without a G.. what I usually do is create an id field, and give that as the index, and auto increment.. but sometimes you might have a field.. like email where you don't want it to ever be a duplicate, in which case you'd set the field 'email' to UNIQUE which is an index but its a unique index, but most of the time you won't need more than a primary index which is just an id field Quote Link to comment https://forums.phpfreaks.com/topic/162576-simple-mysql-index/#findComment-858055 Share on other sites More sharing options...
fenway Posted June 22, 2009 Share Posted June 22, 2009 It all depends on the cardinality of the indexes. Quote Link to comment https://forums.phpfreaks.com/topic/162576-simple-mysql-index/#findComment-860968 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.