2 ms·
I used MySql a lot back then, had many multi-column indexes, and never had an issue. More importantly, given the degree of uniqueness likely to be present in m
by hn_throwaway_99 5y ago
I used MySql a lot back then, had many multi-column indexes, and never had an issue.
More importantly, given the degree of uniqueness likely to be present in many of those columns (like the email addresses), she could have gotten away with not indexing on every column.
- mst 5y agoYour first sentence was, I'm afraid, very much not a universal experience. Your second is quite possibly true, but would have required experimentation to be sure of, and at some point "doing the thing that might be overkill but will definitely work" becomes a more effective use of developer time, especially when you have a groaning production system with live users involved.