ohitsme Posted November 23, 2008 Share Posted November 23, 2008 if i were to have a 40 field table, and put an index on all of them, would it only decrease the time it takes to write? ie read times would either be faster, or same speed? Quote Link to comment https://forums.phpfreaks.com/topic/133942-loads-of-indexes/ Share on other sites More sharing options...
Mchl Posted November 23, 2008 Share Posted November 23, 2008 That should be the case. Although you should actually only create indexes on columns, where you perform searches, sortings, etc... Quote Link to comment https://forums.phpfreaks.com/topic/133942-loads-of-indexes/#findComment-697250 Share on other sites More sharing options...
ohitsme Posted November 24, 2008 Author Share Posted November 24, 2008 ok. yeh, i have no intetion on adding them for more than what i would use in where clauses, but just wanted to check thanks Quote Link to comment https://forums.phpfreaks.com/topic/133942-loads-of-indexes/#findComment-697309 Share on other sites More sharing options...
fenway Posted November 25, 2008 Share Posted November 25, 2008 That should be the case. Unless you index silly columns, particular ENUMs with poor distribution. Quote Link to comment https://forums.phpfreaks.com/topic/133942-loads-of-indexes/#findComment-698853 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.