At 14:12 2018-10-10, "Paul H. Tarver" <[email protected]> wrote:
> This is stupid advice.Don't hold back, Gene! Tell us how you really feel. LOL
In response to someone saying that an arbitrary number of indexes is great advice, I do not think my comment was at all out of line.
I think the point of the article was to help remind people to think about indexes before just using them without understanding the effects on performance. Having a rule of thumb like 5 indexes per table would make me stop and consider whether a 6th index was required. If so, then great. But at least I would have thought about the benefits and negatives before doing it. Frankly, reminding people to consider the consequences of their actions is NEVER stupid advice.
Sure. But putting an arbitrary in is not good advice. In a given case, it might be that having a fifth index is wrong, or maybe, it is fine until the tenth index.
You can consider the pluses and minuses without going arbitrary. After all, the idea of considering things is to avoid arbitraries.
[snip] Sincerely, Gene Wirchenko _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/0c759519b3244a5a4758884dcba22f58@mtlp000085 ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
