The Little Guy Posted June 25, 2009 Share Posted June 25, 2009 Is it better to index rows individually, or as a whole group? Link to comment https://forums.phpfreaks.com/topic/163669-indexing/ Share on other sites More sharing options...
dzelenika Posted June 26, 2009 Share Posted June 26, 2009 Is it better to index rows individually, or as a whole group? Depends of your needs. If most your selects are filtering by only one field then rows individually else whole group. Tip: If you are using a index with more fields and your query don't use first field of index then index won't be used. Link to comment https://forums.phpfreaks.com/topic/163669-indexing/#findComment-864075 Share on other sites More sharing options...
fenway Posted June 27, 2009 Share Posted June 27, 2009 Is it better to index rows individually, or as a whole group? I don't understand the question. Link to comment https://forums.phpfreaks.com/topic/163669-indexing/#findComment-864771 Share on other sites More sharing options...
Ken2k7 Posted June 28, 2009 Share Posted June 28, 2009 You can index rows? Link to comment https://forums.phpfreaks.com/topic/163669-indexing/#findComment-864915 Share on other sites More sharing options...
dzelenika Posted June 28, 2009 Share Posted June 28, 2009 Is it better to index rows individually, or as a whole group? I don't understand the question. In my opinion he wants to know is it better to make few indexes with one row each or one index with few rows. Link to comment https://forums.phpfreaks.com/topic/163669-indexing/#findComment-865011 Share on other sites More sharing options...
fenway Posted June 28, 2009 Share Posted June 28, 2009 In my opinion he wants to know is it better to make few indexes with one row each or one index with few rows. Right, that's the part that doesn't make sense. EDIT: unless row actually means "column". Link to comment https://forums.phpfreaks.com/topic/163669-indexing/#findComment-865045 Share on other sites More sharing options...
dzelenika Posted June 28, 2009 Share Posted June 28, 2009 In my opinion he wants to know is it better to make few indexes with one row each or one index with few rows. Right, that's the part that doesn't make sense. EDIT: unless row actually means "column". str_replace("In my opinion he wants to know is it better to make few indexes with one row each or one index with few rows.", "row", "collumn") My blunder Link to comment https://forums.phpfreaks.com/topic/163669-indexing/#findComment-865102 Share on other sites More sharing options...
fenway Posted June 28, 2009 Share Posted June 28, 2009 Well, let's wait for the OP to clarify. Link to comment https://forums.phpfreaks.com/topic/163669-indexing/#findComment-865126 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.