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? 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 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. Link to comment https://forums.phpfreaks.com/topic/162576-simple-mysql-index/#findComment-860968 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.