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