2 ms·
I found this deeply ironic given the article's premise: "are any of my queries are doing table scans?" It makes me grind my teeth when developers apply brute
by abraae 11y ago
I found this deeply ironic given the article's premise:
"are any of my queries are doing table scans?"
It makes me grind my teeth when developers apply brute force thinking like this. There are many times when full tables scans are fine - e.g. used on a small table, or when a query returns more than a few percent of the rows in a table.
imo, blindly hunting out full table scans is a textbook case of premature optimization.
- jerf 11y agoHas it occurred to you that, in context, there's no way I meant blindly checking? Besides, this may "grind your teeth" but I see the opposite at least a full order of magnitude more often, if not two. I'm far more likely to get someone asking me "What's EXPLAIN?" (when working with MySQL) than to see someone going nuts making sure they have 0 table scans.