At 14:12 2018-10-10, "Paul H. Tarver" <paul(a)tpcqpc.com> 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