The Little Guy Posted June 25, 2009 Share Posted June 25, 2009 Is it better to index rows individually, or as a whole group? Quote Link to comment 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. Quote Link to comment 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. Quote Link to comment Share on other sites More sharing options...
Ken2k7 Posted June 28, 2009 Share Posted June 28, 2009 You can index rows? Quote Link to comment 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. Quote Link to comment 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". Quote Link to comment 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 Quote Link to comment 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. 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.